LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
delete sheets from a workbook without creating linked formulae BlueTig Excel Discussion (Misc queries) 3 August 23rd 06 08:39 AM
How to search for grouped rows? Minerva Excel Worksheet Functions 1 June 27th 06 06:18 AM
excel 03- sheets stay grouped even when I ungroup TGilboy Excel Discussion (Misc queries) 1 June 3rd 06 02:00 PM
IF formula in Excel / Replace numbers with 'words' Emsmaps Excel Discussion (Misc queries) 1 April 7th 06 11:01 PM
Insert rows to linked spreadsheets Nicole Excel Worksheet Functions 8 August 19th 05 04:20 PM


All times are GMT +1. The time now is 02:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"