| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamically change accumulation links when adding worksheets
U can use the worksheet_activate event of the Summary worksheet. Using VBA
code you can use the sheet number to determine the most recent Detail sheet, or some other unique pattern. Then you can update the formula in the Summary sheet with the correct reference. Jason |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamically adding code | Excel Programming | |||
| Quick question about dynamically adding and naming worksheets | Excel Programming | |||
| Adding Pivot Tables Dynamically | Excel Programming | |||
| Emergency ( Adding Worksheets dynamically in Workbookds) | Excel Programming | |||
| Adding button dynamically | Excel Programming | |||
Hybrid Mode
