Transferring data

[UniversalJOC]

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]

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]

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?