Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update one worksheet tab to automatically update all other tabs? | Excel Worksheet Functions | |||
How do I automatically update my accountability worksheet from my | Excel Worksheet Functions | |||
Copy data into another worksheet and have it update automatically? | Excel Discussion (Misc queries) | |||
Copy data into another worksheet and have it update automatically? | Excel Discussion (Misc queries) | |||
Can I update a worksheet automatically while it's open elswhere? | Excel Discussion (Misc queries) |