Replace with Grouped Sheets

[Guest]

I have 32 identical sheets. In cell D311 of sheet1
I have
=+D107+D109+D110+D111+D115+D116+D117+D119+D121+D122+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

 

[Bob Phillips]

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)

 

[Guest]

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

 

[Gord Dibben]

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

 

[Guest]

Thanks Gord for the clarification;
Jim

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