Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace with Grouped Sheets
I have 32 identical sheets. In cell D311 of sheet1
I have =+D107+D109+D110+D111+D115+D116+D117+D119+D121+D12 2+D123+D124 The same above formula is in all the other (31) cells between sheet2 and sheet32. Occasionally I need to change D311 (and on all the sheets); My first attempt was to: 1) Group all sheets (1 - 31), 2) then in sheet1 with cell D311 active, F2 on it and clear(delete) +D116+D117+D119 hoping that after I pressed ENTER cell D311 ON ALL my Sheets would show =+D107+D109+D110+D111+D115+D121+D122+D123+D124 It did so on Sheet1, but not on sheet2 thru sheet31; I've changed my go at it with using the REPLACE (from the Find and replace Dialog box) - still with all sheets GROUPED and indicating the WITHIN: Workbook << Option It works on all me sheets 1 - 31 After Grouping and Prior to bringing up the F/R dialog box, I have only Cell D311 on Sheet1 selected. My Question IS.... Is Cell D311 ONLY (on all the sheets) changed? No other Cells are getting changed ,,,, RIGHT? Many Thanks (in advance), Jim May |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
delete sheets from a workbook without creating linked formulae | Excel Discussion (Misc queries) | |||
How to search for grouped rows? | Excel Worksheet Functions | |||
excel 03- sheets stay grouped even when I ungroup | Excel Discussion (Misc queries) | |||
IF formula in Excel / Replace numbers with 'words' | Excel Discussion (Misc queries) | |||
Insert rows to linked spreadsheets | Excel Worksheet Functions |