copy values from multiple files

[adamskiadam]

Hi there,

There must be a really easy solution to my problem and i've really tried to figure it out myself but to no luck. I also tried to search but I don't really know what terms to use so I apologize if it is asked and answered somewhere already.

I have several documents that I want to merge to one single excel file. So just adding rows to the master record. The documents that I want to merge all have the same layout.

Using consolidate data I can only get it to sum the records however I just want to copy them and then to be able to sort the list.

Regards
Adam

[Roger Govier]

Hi

Take a look at the code solutions provided by Ron de Bruin for achieving this
http://msdn.microsoft.com/en-us/library/cc837974.aspx

[dailyglobal]

You can use below VB code to serve your purpose. Hope it will help you.

To open VB editor press alt+F11

Please Login or Register  to view this content.

[Roger Govier]

You can use below VB code to serve your purpose. Hope it will help you.

Please use CODE tags if you are going to post code samples, and, where you are posting code which is not your own, have the courtesy to acknowledge the author.

This code was written by Ron de Bruin.