Excel VBA

Closed
Dausa - Nov 22, 2011 at 01:01 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 23, 2011 at 05:29 AM
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.
Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Nov 23, 2011 at 05:29 AM
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.
0