| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Relative worksheet reference in 3-D formulas?
Gang -
I have a workbook with a summary worksheet at the first tab, and then a new worksheet inserted every quarter as the second tab. Earlier quarters are pushed to the right on the tabs. Is there a way to reference data on the second tab no matter what that second worksheet is titled? It changes every quarter. Right now I do a global replace manually via menu. Thanks in advance. ....best, Hash |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
| Using a cell reference to refernce worksheet in another work book | Excel Worksheet Functions | |||
| how do I make a copy of a worksheet and retain formulas but not data | Setting up and Configuration of Excel | |||
| Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
| Reference Data in Moved Worksheet | Setting up and Configuration of Excel | |||
Threaded Mode
