Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing multiple worksheet references in formulae
Hi,
I have a workbook containing 60 worksheets (4 worksheets for 15 different categories). I have build a model on 1 category and am looking to copy the 4 worksheets for each of the other 14 categories (hence copying the formulas over). I was hoping that this wopuld allow me to simply enter raw data into the first worksheet and the other 3 worksheets for that category would populate automatically. Obviously this means that the formula would need to update (which they don't- they point to the right cells but the worksheet name is wrong). Is there any way I can easily replace the worksheet reference in the formulae easily i.e. find & replace ? Any help appreciated! cheers, R |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing multiple worksheet references in formulae
R,
Select all the cells, press Ctrl-H to get the find/replace dialog, Find What: Sheet1 Replace with: Sheet2, click the options button, choose Look In: Formulas, and click Replace All Of course, use the actual sheet names instead of sheet1 and sheet2. HTH, Bernie MS Excel MVP "kippers" wrote in message ... Hi, I have a workbook containing 60 worksheets (4 worksheets for 15 different categories). I have build a model on 1 category and am looking to copy the 4 worksheets for each of the other 14 categories (hence copying the formulas over). I was hoping that this wopuld allow me to simply enter raw data into the first worksheet and the other 3 worksheets for that category would populate automatically. Obviously this means that the formula would need to update (which they don't- they point to the right cells but the worksheet name is wrong). Is there any way I can easily replace the worksheet reference in the formulae easily i.e. find & replace ? Any help appreciated! cheers, R |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing multiple worksheet references in formulae
awesome- cheers Bernie
"Bernie Deitrick" wrote: R, Select all the cells, press Ctrl-H to get the find/replace dialog, Find What: Sheet1 Replace with: Sheet2, click the options button, choose Look In: Formulas, and click Replace All Of course, use the actual sheet names instead of sheet1 and sheet2. HTH, Bernie MS Excel MVP "kippers" wrote in message ... Hi, I have a workbook containing 60 worksheets (4 worksheets for 15 different categories). I have build a model on 1 category and am looking to copy the 4 worksheets for each of the other 14 categories (hence copying the formulas over). I was hoping that this wopuld allow me to simply enter raw data into the first worksheet and the other 3 worksheets for that category would populate automatically. Obviously this means that the formula would need to update (which they don't- they point to the right cells but the worksheet name is wrong). Is there any way I can easily replace the worksheet reference in the formulae easily i.e. find & replace ? Any help appreciated! cheers, R |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing all formulae in a worksheet from absolute to relative | Excel Discussion (Misc queries) | |||
Chart data references not changing to new tab when worksheet is co | Charts and Charting in Excel | |||
Changing formulae to their value | Excel Discussion (Misc queries) | |||
References to worksheets in formulae | Excel Discussion (Misc queries) | |||
Changing Cell References To a Different Worksheet in the Same Cell | Excel Worksheet Functions |