"michael.beckinsale" wrote:


Many thanks for the code which appears to work very well.
You're very welcome


I will probably make some small amendments (determine last column,
last row etc) to make the code as efficient as possible....

There is probably a more efficient way of finding the last row in the master
sheet.

Another good optimisation would be:
- First find out how many rows are to be appended using some efficient
algorithm
- Then, in the loop that matches columns between source and destination, use
Copy for all the values in the source col starting at row 2 ending at the
last row and paste values into the master sheet col starting at the first
blank row. That would be very quick and avoids a loop down the rows.

I also suggest you save and turn off calculations/screenupdating at the
start of the function then restore at the end.

and also
because it will be run on Excel 2007.
Is there anything in particular l should look out for?


I don't know of any specific 2007 points.

Again many thanks for your help,

Regards

Michael