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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace with Grouped Sheets
Wrong. They should all get changed just as you expect.
I did just try (with 4 sheets), but it worked exactly as you wanted. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Jim May" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace with Grouped Sheets
Sorry Bob, but I'm not understanding...
What I was trying to say was.. Within the Grouped Sheets of the entire Workbook -- ONLY cell D311 is being CHANGED in all sheets sheet1-sheet31; My tests indicate any other cells in the grouped sheets, say B211 which might have in it +D116+D117+D119 IS NOT Affected. Jim "Bob Phillips" wrote: Wrong. They should all get changed just as you expect. I did just try (with 4 sheets), but it worked exactly as you wanted. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Jim May" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace with Grouped Sheets
Jim
Within the grouped sheets, D311 is the only cell you are editing. Naturally B211 will not be edited on any sheet. If you use the Find and Replace with all cells selected, the replace should occur in every cell across the sheets if you specify Workbook in Options. Gord Dibben MS Excel MVP On Thu, 14 Sep 2006 12:41:01 -0700, Jim May wrote: Sorry Bob, but I'm not understanding... What I was trying to say was.. Within the Grouped Sheets of the entire Workbook -- ONLY cell D311 is being CHANGED in all sheets sheet1-sheet31; My tests indicate any other cells in the grouped sheets, say B211 which might have in it +D116+D117+D119 IS NOT Affected. Jim "Bob Phillips" wrote: Wrong. They should all get changed just as you expect. I did just try (with 4 sheets), but it worked exactly as you wanted. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Jim May" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace with Grouped Sheets
Thanks Gord for the clarification;
Jim "Gord Dibben" wrote: Jim Within the grouped sheets, D311 is the only cell you are editing. Naturally B211 will not be edited on any sheet. If you use the Find and Replace with all cells selected, the replace should occur in every cell across the sheets if you specify Workbook in Options. Gord Dibben MS Excel MVP On Thu, 14 Sep 2006 12:41:01 -0700, Jim May wrote: Sorry Bob, but I'm not understanding... What I was trying to say was.. Within the Grouped Sheets of the entire Workbook -- ONLY cell D311 is being CHANGED in all sheets sheet1-sheet31; My tests indicate any other cells in the grouped sheets, say B211 which might have in it +D116+D117+D119 IS NOT Affected. Jim "Bob Phillips" wrote: Wrong. They should all get changed just as you expect. I did just try (with 4 sheets), but it worked exactly as you wanted. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Jim May" wrote in message ... 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 |
Reply |
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 |