Thanks for that Merjet :D

I was able to adapt the code to one of the problems set before m
however I have the same problem on another file. This one differs i
that:

* The Master file is to be populated from other files (my knowledge o
VB is poor at best so i don't even know if this is possible)

* The criteria column (called "Upload") may be populated with a "Y"
"N" or be left blank. I only want to copy across the rows with a "Y".
I noticed on the first code you provided that if the criteria column i
left blank it moves on to the next worksheet - how do i change the cod
so that this does not occur?

Any help on this would be very much appreciated.

Cheers

Au

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com