Replacing a Worksheet

  • Thread starter Thread starter fiset
  • Start date Start date
F

fiset

Hi. I've got Workbook 1 and Workbook 2 open on my screen. I want t
*replace* Worksheet A from Workbook 1 with Worksheet A from Workboo
2.

Using the Move_or_Copy function, I can move Worksheet A from Workbook
in front of or behind Worksheet A from Workbook 1 but I want t
actually *replace* the worksheet not juist add it to Workbook 1. Doe
that make sense? Is there a way to do that
 
Not really sure what you're driving at, I'm afraid ....

When you move/copy over worksheet A from workbook 2
to workbook 1 [which has an identical named worksheet A]
Excel will name the sheet as "A (2)"

You can then just delete the "original" worksheet A
and rename the imported sheet from "A (2)" to "A" ??

Or, if only values are involved in worksheet A,
maybe just do a copy > paste special > values
from workbook 2 to book 1 to overwrite will do?

In worksheet A in workbook 2
-------------------------------------
Press Ctrl + A
[this selects the entire sheet]

Click Copy

In worksheet A in workbook 1
 
Back
Top