Can I Move replace instead of Move copy

[ato_zee]

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?

 

[MartinW]

Hi,

You can right click on sheet1 and delete it after the copy
then double click on sheet2 and rename it.

Alternatively you can put this formula in cell A1 of Book2 Sheet1
=IF([Book1]Sheet1!A1="","",[Book1]Sheet1!A1)
Then click on the fill handle and drag it down as far as is needed,
then with the whole column highlighted click on the fill handle
again and drag it across as far as is needed.

That way any entry made in Book1 will automatically go into
Book2 provided both files are open.

HTH
Martin

 

[ato_zee]

Many thanks I'll give it a try.
I just want the Sheet Index number to
stay the same, so the macros which
refer to Sheet1 still work.
The don't if the copy becomes
Sheet2.