Automatically update excel worksheet formula

R

Robin

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

T. Valko

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.
 
G

Gord Dibben

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
 
E

Emma Dust

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 t
include and name this new sheet First. Insert a new sheet immediately to th
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 th
Last sheet

-
Bif
Microsoft Excel MVP

Previous Posts In This Thread:

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

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

Insert a new sheet immediately to the left of the first sheet you want t
include and name this new sheet First. Insert a new sheet immediately to th
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 th
Last sheet

-
Bif
Microsoft Excel MVP

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 summar
sheet.....name it star

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

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 MV

wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Get Started with SQLite and Visual Studio
http://www.eggheadcafe.com/tutorial...b-b6f46d4f2c6a/get-started-with-sqlite-a.aspx
 
E

Emma Dust

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 t
include and name this new sheet First. Insert a new sheet immediately to th
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 th
Last sheet

-
Bif
Microsoft Excel MVP

Previous Posts In This Thread:

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

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

Insert a new sheet immediately to the left of the first sheet you want t
include and name this new sheet First. Insert a new sheet immediately to th
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 th
Last sheet

-
Bif
Microsoft Excel MVP

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 summar
sheet.....name it star

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

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 MV

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/tutorial...2e-39384482c80e/featured-product--servic.aspx
 
E

Emma Dust

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 t
include and name this new sheet First. Insert a new sheet immediately to th
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 th
Last sheet

-
Bif
Microsoft Excel MVP

Previous Posts In This Thread:

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

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

Insert a new sheet immediately to the left of the first sheet you want t
include and name this new sheet First. Insert a new sheet immediately to th
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 th
Last sheet

-
Bif
Microsoft Excel MVP

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 summar
sheet.....name it star

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

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 MV

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

Sheet sandwich %
ok have sorted it.


Submitted via EggHeadCafe - Software Developer Portal of Choice
More Fun with Fluent NHibernate Automapping
http://www.eggheadcafe.com/tutorial...9-81ee42171b00/more-fun-with-fluent-nhib.aspx
 
E

Emma Dust

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 t
include and name this new sheet First. Insert a new sheet immediately to th
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 th
Last sheet

-
Bif
Microsoft Excel MVP

Previous Posts In This Thread:

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

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

Insert a new sheet immediately to the left of the first sheet you want t
include and name this new sheet First. Insert a new sheet immediately to th
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 th
Last sheet

-
Bif
Microsoft Excel MVP

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 summar
sheet.....name it star

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

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 MV

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

Sheet sandwich %
ok have sorted it.

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/tutorial...d8-3e2773fa29b5/whats-new-for-developers.aspx
 
T

Toothsome Papa

mmmmmmm sheet sandwich

Emma Dust said:
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:

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 ?

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

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:

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

Sheet sandwich %
ok have sorted it.

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/tutorial...d8-3e2773fa29b5/whats-new-for-developers.aspx
.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sorting data from one table/range to another table/range 1
Skipping a cell and moving on to the next, with no blanks in betwe 8
SumIf with multiple Criteria 6
Worksheet Links 1
Worksheet 1 exact copy of worksheet 2, but in different order 1
Splitting text strings along commas. 3
Code to copy the last row formulas and paste it in the bottom row 3
Summing/counting data when columns match each other 2

Top