Macros for copying the data

[mehta_agm]

Hi Freinds,
can some body help me with this common problem....
I am trying to create a macro to access an excel file (for example
"file2")kept in our shared drive.

I require the data from columns A & Col B of "File2" and paste it in
"file 1" sheet 2. Also i need this macro to be kept in the "file1"

But the problem is that the data in the file 2 keeps on changing.....I
dont know how shud i go abt creating this macro.

Any help is appreciated

Anand

 

[Dave Peterson]

Open File 1
Record a macro when you open File2.
Keep recording when you copy the data you want (A1:Bxx)
and record when you paste into the correct worksheet in File1.
and record when you close file2 without saving.