I have 2 workbooks, and need to synchronise WorkSheet1
of one workbook with WorkSheet1 in another workbook.
The Create a copy only lets me copy, not replace.
So if I copy from Workbook1 to Workbook2 the copied
sheet becomes Worksheet2
I want the Copy to replace the contents of Worksheet1
but there is no Copy Replace option between workbooks.
Is there a simple way to do this?