Posted to microsoft.public.excel.misc
|
|
Sheet sandwich %
mmmmmmm sheet sandwich
"Emma Dust" wrote:
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.
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
What's New for Developers in SharePoint 2010 Object Model?
http://www.eggheadcafe.com/tutorials...evelopers.aspx
.
|