Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros for copying the data
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros for copying the data
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macros for copying external data to Excel | Excel Discussion (Misc queries) | |||
Macros - copying macros from one computer to another | Excel Discussion (Misc queries) | |||
copying macros | Excel Worksheet Functions | |||
copying macros | Excel Worksheet Functions | |||
Copying data from another cell, I think there are macros | Excel Discussion (Misc queries) |