| Home |
| Search |
| Today's Posts |
|
|
|
#1
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) | |||
Hybrid Mode
