Excel VBA

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

Please, I face difficulties to come into solution on one issue about how to use vba & one cell of a sheet1 to enter data into cells on another sheet2. eg Use cell ("a1") of Sheet1 enter data into cell of Column a1,Column a2,Column a3, Column a4 etc of sheet2

Thank
Dauda Muhammad
Kano,
Nigeria.

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
not clear
sheet 2 all the cells in columns A contain the same value as a1 of sheet 1??????

why vba is required

selecct cells in sheet 2 form A1 down as many as you require
type
=sheet1!A1
hit control shift enter.