Prev: Sorting
Next: Summing Data based upon a condition
From: LB on 8 Apr 2010 13:02
I want to copy a worksheet names WK 15 that has several formulas in linking
to WK 15 of other sheets, then paste it to create another workbook but
changing all the formulas to WK16 and not WK15 but keeping all of the other
data within the pasted formula the same.

EG: SUM('Y:\AREA\PARADE\[WK 16.xls]Sheet1'!D$6) and various similar formula
to be copied and paste onto a new workbook but change [WK16.xls] to
[WK17.xls] only within all of the formula so I do not have to keep manually
changing each cells formula myself.
From: Pete_UK on 8 Apr 2010 14:04
You can create a copy of the worksheet by holding the CTRL key down
and dragging the sheet tab along the bottom of the file window - a
little arrow will indicate where the copy will be positioned. Then you
can select all the cells in the copied sheet by clicking on the
intersection of the row and column identifiers (or by doing CTRL-A
twice). Then do CTRL-H (Find & Replace), and:

Find What: [WK 16.xls]
Replace With: [WK 17.xls]
Click Replace all.

Then you can rename the (copied) sheet as appropriate.

Hope this helps.

Pete

On Apr 8, 6:02 pm, LB <L...(a)discussions.microsoft.com> wrote:
> I want to copy a worksheet names WK 15 that has several formulas in linking
> to WK 15 of other sheets, then paste it to create another workbook but
> changing all the formulas to WK16 and not WK15 but keeping all of the other
> data within the pasted formula the same.
>
> EG: SUM('Y:\AREA\PARADE\[WK 16.xls]Sheet1'!D$6) and various similar formula
> to be copied and paste onto a new workbook but change [WK16.xls] to
> [WK17.xls] only within all of the formula so I do not have to keep manually
> changing each cells formula myself.

 | 
Pages: 1
Prev: Sorting
Next: Summing Data based upon a condition