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