Copy and replace worksheet from one workbook to another

This is very easily done.

You could record yourself doing this.

Start the macro recorder.

activate "daily reports.xls"
activate "master data.xls"
Right click on the sheet name Shee1 at the bottom of excel and select delete
activate "daily reports.xls"
right click on the sheet name Sheet1 at the bottom of excel and select move/copy
click on the copy box
select copy and use the browser to select "master data.xls"

Stop the recorder.

Now that will work. But it will get annoying because you will get an alert telling you that you might lose data.

So you need to disable alerts before you delete the sheet and reinstate them afterwards.

You might lso want to switch off screen updates.

These lines of code are all you need to add:

Please Login or Register  to view this content.

This is what I recorded and edited:

Please Login or Register  to view this content.