Replacing a Worksheet

[Lucas Ford]

Is there a way to replace a worksheet with a worksheet from another
workbook? For example, I have Workbook 1 and Workbook 2 open. I want
to replace Worksheet 1 from the first Workbook with Worksheet 3 from
the second Workbook. Any ideas? Thanks again for any help you can
give this newbie.

 

[Lucas Ford]

Thanks for the response Mark. Question though. I know about the
Move_or_Copy function but when using it, I can only move a copied
worksheet from workbook 2 *before* another worksheet in Workbook 1. I
want to *replace* a worksheet in Workbook 1 with a worksheet from
workbook 2. Does that make sense?

 

[Mark Graesser]

Lucas
Can't you just copy the new sheet in and then delete the other sheet

Or are there links to the sheet you are replacing, and you want the links to point to the same locations in the replacement sheet? Then you could click on the gray rectangle in the upper left corner of the sheet (above the "1" and left of the "A") to select the entire sheet. Then Copy and paste to cell A1 of the sheet you want to replace. This way you aren't actually replacing the sheet, but you will be replacing the contents of the sheet. This will bring over all of the formatting as well

Hope this helps

Good Luck
Mark Graesse
(e-mail address removed)
Boston M

----- Lucas Ford wrote: ----

Thanks for the response Mark. Question though. I know about th
Move_or_Copy function but when using it, I can only move a copie
worksheet from workbook 2 *before* another worksheet in Workbook 1.
want to *replace* a worksheet in Workbook 1 with a worksheet fro
workbook 2. Does that make sense