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 ?

Automatically update excel worksheet formula
 

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


"Robin" wrote in message
...
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 ?

Automatically update excel worksheet formula
 

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

On Mon, 17 Aug 2009 10:17:01 -0700, Robin
wrote:

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 ?

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) ?



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:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Get Started with SQLite and Visual Studio
http://www.eggheadcafe.com/tutorials...-sqlite-a.aspx

Sheet sandwich %
 

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) ?


Submitted via EggHeadCafe - Software Developer Portal of Choice
Featured Product / Service Review: TekPub
http://www.eggheadcafe.com/tutorials...t--servic.aspx

Sheet sandwich %
 

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

Sheet sandwich %
 

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

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
.