ok have sorted it.



T. Valko wrote:

Create a "sheet sandwich".
17-Aug-09

Create a "sheet sandwich".

Insert a new sheet immediately to the left of the first sheet you want to
include and name this new sheet First. Insert a new sheet immediately to the
right of the last sheet you want to include and name this new sheet Last.

Then use this formula:

=Min(First:Last!C51)

When you insert new sheets just move them between the First sheet and the
Last sheet.

--
Biff
Microsoft Excel MVP

Previous Posts In This Thread:

On Monday, August 17, 2009 1:17 PM
Robi wrote:

Automatically update excel worksheet formula
What is the formula or instruction that allows summary data from
Worksheet1:Worksheet? to automatically update when a new worksheet is added.
Example: the Summary sheet has the following formula
=Min(Worksheet1:Worksheet5!C51), then another worksheet is inserted
(Worksheet6). Is there a way to have Excel automatically update that formula
to become =Min(Worksheet1:Worksheet6!C51)? Would you do that with a Macro
and how could this be accomplished ?

On Monday, August 17, 2009 1:28 PM
T. Valko wrote:

Create a "sheet sandwich".
Create a "sheet sandwich".

Insert a new sheet immediately to the left of the first sheet you want to
include and name this new sheet First. Insert a new sheet immediately to the
right of the last sheet you want to include and name this new sheet Last.

Then use this formula:

=Min(First:Last!C51)

When you insert new sheets just move them between the First sheet and the
Last sheet.

--
Biff
Microsoft Excel MVP

On Monday, August 17, 2009 1:34 PM
Gord Dibben wrote:

The easiest method is to insert a new sheet to the right of summarysheet.....
The easiest method is to insert a new sheet to the right of summary
sheet.....name it start

Insert a new sheet at end.............name it end

in a summary sheet =MIN(start:end!C51)

When inserting new sheets place them between start and end sheets.

start and end are the bread, other sheets are the peanut butter.


Gord Dibben MS Excel MVP

wrote:

On Wednesday, March 03, 2010 5:54 AM
Emma Dust wrote:

Sheet sandwich %
Have created a sheet sandwich but how do i divide all the numbers to create a % (will still need to be a sheet sandwich) ?

On Wednesday, March 03, 2010 6:02 AM
Emma Dust wrote:

Sheet sandwich %
ok have sorted it.


Submitted via EggHeadCafe - Software Developer Portal of Choice
More Fun with Fluent NHibernate Automapping
http://www.eggheadcafe.com/tutorials...uent-nhib.aspx