Hi

Is there anyway to copy or move sheets between work books, so that the sheets you are moving will replace the existing ones. The sheets in the two workbooks have the same names, but each time I try and move or copy them, excel just adds them to the existing workbook with a (2) suffix to the name, but I want the new sheets to actually replace the old ones.

Can this be done?

Thanks.