| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
replacing just the sheet names within formulas
I have a multisheet workbook. I need to regularly replace the sheet name
with the formulas. I need to replace December04 with Jan05 etc. Formula - cell references will change in each cell. Lookup and MTD_Actuals are named ranges on another sheet w/i book. =SUMIF('File Name.xls'!Lookup,December04!$A7&$D$5&D$6,'File Name.xls'!MTD_Actuals) |
|
#2
|
|||
|
|||
|
Hi
you could try using 'Edit - Replace' for this -- Regards Frank Kabel Frankfurt, Germany "Jeanne Criez" <Jeanne schrieb im Newsbeitrag ... I have a multisheet workbook. I need to regularly replace the sheet name with the formulas. I need to replace December04 with Jan05 etc. Formula - cell references will change in each cell. Lookup and MTD_Actuals are named ranges on another sheet w/i book. =SUMIF('File Name.xls'!Lookup,December04!$A7&$D$5&D$6,'File Name.xls'!MTD_Actuals) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rules for Sheet names | Excel Discussion (Misc queries) | |||
| Locking Sheet names in formulas | Excel Worksheet Functions | |||
| How can I show sheet names in different colours | New Users to Excel | |||
| Listing of Sheet names | Excel Worksheet Functions | |||
| Naming & renaming a sheet tab | Excel Worksheet Functions | |||
Linear Mode
