Transferring data

UniversalJOC · Feb 26th, 2002, 05:35 AM

I have excel documents that I need to try and automate the transfer of certain data(eg - omitting the first two columns) to a 'mother' worksheet. the location that the data is sent to depends on the file name that the data has come from.
if the mothersheet has the file names (containing the data in question) listed is it possible to create a button that will sort and transfer the files. (I hope this makes some kind of sense)

Damon Ostrander · Feb 26th, 2002, 02:33 PM

Hi UniversalJOC,

Yes, this is the type of thing that macros do quite well. Obviously I can't speak specifically regarding your problem without more information, but I can at least assure you that that it is inherently an easy problem with a bit of VBA code.

UniversalJOC · Feb 27th, 2002, 01:43 AM

Basically, I have just created a button to find and open certain *.* files. Once they have been opened I am hoping to transfer core date from them to automate a mail merge.
it would need to locate data (eg all data minus columns A and B) from the opened files (as the amount fluctuates) and transfer that data to the main spreadsheet, the location dependant upon the file name it came from. Another button would allow each 'location' store of data to be merged with a certain letter file (again discerned by the filename).
Does this make any more sense?

Feb 26th, 2002, 02:33 PM	#2
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	Hi UniversalJOC, Yes, this is the type of thing that macros do quite well. Obviously I can't speak specifically regarding your problem without more information, but I can at least assure you that that it is inherently an easy problem with a bit of VBA code. __________________ Keep Excelling. Damon VBAexpert Excel Consulting (My other life: http://damonostrander.com )

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 26th, 2002, 05:35 AM	#1
UniversalJOC New Member Join Date: Feb 2002 Posts: 40	I have excel documents that I need to try and automate the transfer of certain data(eg - omitting the first two columns) to a 'mother' worksheet. the location that the data is sent to depends on the file name that the data has come from. if the mothersheet has the file names (containing the data in question) listed is it possible to create a button that will sort and transfer the files. (I hope this makes some kind of sense)

Feb 27th, 2002, 01:43 AM	#3
UniversalJOC New Member Join Date: Feb 2002 Posts: 40	Basically, I have just created a button to find and open certain . files. Once they have been opened I am hoping to transfer core date from them to automate a mail merge. it would need to locate data (eg all data minus columns A and B) from the opened files (as the amount fluctuates) and transfer that data to the main spreadsheet, the location dependant upon the file name it came from. Another button would allow each 'location' store of data to be merged with a certain letter file (again discerned by the filename). Does this make any more sense?