| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Table of Contents - Data from unhidden sheets only
I have a financial planning workbook with 30 sheets. The book has a table of
contents that is created manually by pulling info from cell A1 of each sheet. However, we hide certain sheets depending on the situation. The sheets that are hidden in any given situation is unpredictable. Is there a way to automate pulling data only from the unhidden sheets and then putting it onto a table of contents page? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumproduct with unhidden data | Excel Worksheet Functions | |||
| Pivot Table COUNTA SUM of Unhidden cells only | Excel Worksheet Functions | |||
| Pivot Table Counta formula and sum for unhidden cells only | Excel Discussion (Misc queries) | |||
| How can I combine data from two sheets where field contents match? | Excel Worksheet Functions | |||
| Calculations on Only Unhidden Data Cells | Excel Discussion (Misc queries) | |||
Threaded Mode
