Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to copy & paste a worksheet but change 1 bit of the formula?
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to copy & paste a worksheet but change 1 bit of the formula?
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 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy & paste worksheet with print settings into new worksheet | Excel Discussion (Misc queries) | |||
Data Change after Copy/Paste | Excel Discussion (Misc queries) | |||
Formula copy paste down in a sheet but change row letter increment | Excel Discussion (Misc queries) | |||
copy & paste and change format | Excel Worksheet Functions | |||
how do i copy formula and change worksheet instead of cell | Excel Worksheet Functions |