|how can I pull data from worksheet 2 to |
display in worksheet 1? please help... i don't
know how to put vb codes in the worksheets...
How do i automatically get the data from sheet
2 to sheet 1.
I have a lot of forms in sheet 2. Inside the form,
there are 'names, age, dob, etc'. (1st name in
J4, 2nd name in j52, 3rd name in j100)
If i wanna get the 'names' from sheet 2 to
sheet 1 but in a continuing number (1st name
in A1, 2nd name in A2, 3rd name in A3).
What formula should i use?
So i can get the data automatically just by
puling and dragging the box down as the
formula will be automatically copied
Thank you so much for your help.