Copy data from another sheet

Microsoft Office excel 2003
May 30, 2010 at 21:21:28
Specs: Windows XP
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.

For example:
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.

See More: Copy data from another sheet

Report •

May 30, 2010 at 21:53:42
For more help you would be better advised to post this query here:

Report •
Related Solutions

Ask Question