Merging data from several different spreadsheets

[Lahuka]

Hi all, this is my first post and was wondering if anyone could help me out with my limited Excel VBA knowledge?

Basically I have the attached spreadsheet several times with different info on each. If you look at the NonSap tab you will notice that data is present for the Elec Acquisitions process. Each different spreadsheet will have data for 1 or 2 of the processes.

I have got some code that will loop through and get the names of all the spreadsheets, and open them one after the other, and I need some code that will identify which cells have been populated, and then copy them over to a master spreadsheet.

If anyone can help I will be very grateful as I have been trying to get my head around how to do this for a while now!

Cheers

Luke

[JBeaucaire]

Your code works very well so far. You know where the top of the data range is, always starts at row11. If you add a variable to spot the bottom of the data on each worksheet, it makes copying to another sheet very simple. Here's a macro:

Please Login or Register  to view this content.

I've installed in your sheet and added a new button to run it. Pick a Process then click the new button.