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.


mehta_agm wrote:

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


--
mehta_agm
------------------------------------------------------------------------
mehta_agm's Profile: http://www.excelforum.com/member.php...o&userid=30518
View this thread: http://www.excelforum.com/showthread...hreadid=501936

--

Dave Peterson