Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 210
Default 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 ?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15,768
Default 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 ?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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 ?


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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


  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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
  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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
  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default 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
.

Reply
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
Update one worksheet tab to automatically update all other tabs? shoechic1 Excel Worksheet Functions 1 May 24th 09 03:55 PM
How do I automatically update my accountability worksheet from my mls Excel Worksheet Functions 1 February 7th 07 08:49 PM
Copy data into another worksheet and have it update automatically? Taxed Mind Excel Discussion (Misc queries) 4 October 6th 06 12:17 AM
Copy data into another worksheet and have it update automatically? Lmarie6 Excel Discussion (Misc queries) 10 March 31st 06 04:57 PM
Can I update a worksheet automatically while it's open elswhere? Ryan Excel Discussion (Misc queries) 0 October 19th 05 06:18 PM


All times are GMT +1. The time now is 09:21 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"