Hi Metrazol,

My previous post is a sub, and should be placed in a standard module.
Disregard all previous examples because the last one copies the active sheet
("Master") into your existing file. The comments at the beginning of the
procedure explain what it does, while each process within the procedure has
comment that outline the steps.

Just call the procedure, or assign it to a button. Make sure the "Master"
sheet you want to copy into the other workbook is active. (the one you're
working on)

Regards,
GS


"Metrazal" wrote:


Can you explain this? Is this a seperate sub/module? Please advise.

Thanks,

MET


--
Metrazal
------------------------------------------------------------------------
Metrazal's Profile: http://www.excelforum.com/member.php...o&userid=31648
View this thread: http://www.excelforum.com/showthread...hreadid=518833