| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reference other worksheet
I have a workbook with 5 worksheets. Sheet 1 is a summary of data on sheets
2-5. Sheet 1 will always be named "summary", but the names of sheets 2-5 will change monthly. How can I "generically" reference sheets 2-5 so I don't have to change the formulas on my summary sheet each month? In other words, if the name of sheet 2 is "FLX_75" this month and next month it is "FLX_79", how do I write the formula to pull data from the correct worksheet without having to edit it each month. The formula will always reference the same CELLS on these worksheets, so I only need the changing worksheet. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to Create New Worksheet and Reference Cell in Old Worksheet As Tab Name - "Object Required" Error | Excel Discussion (Misc queries) | |||
| I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
| Reference the worksheet from a multiple worksheet range function ( | Excel Worksheet Functions | |||
| Can the offset worksheet function reference another worksheet | Excel Worksheet Functions | |||
| Worksheet reference (i.e placing worksheet name in a cell) | Excel Worksheet Functions | |||
Threaded Mode
