View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim May Jim May is offline
external usenet poster
 
Posts: 477
Default 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