Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Interrogating Data on Hidden Sheets
I have a workbook with 5 Sheets:
Main: Contains the user console Report: Contains a formatted & filtered list of data based on the criteria selected in Main Imported Data (Hidden): Contains the raw data imported from a file Statistics: Contains summary information sourced from "Report" I set a series of COUNTIF formulae in "Statistics" to read off "Report" the number of occurances of particular criteria. Easy. But when the list is filtered, it loses the reference to the "Report" worksheet (even though it is not hidden, just filtered) The other alternative is to access the "Imported Data" sheet, but since this is hidden, the macro can't find it. The Statistics fomulae need to be dynamic, so it always reads live information, so running an unhide/hide function is useless. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data on hidden sheets | Excel Discussion (Misc queries) | |||
Userform data entry into hidden sheets | Excel Programming | |||
interrogating a workbook WITHOUT opening it from VBA | Excel Programming | |||
Interrogating Data in Excel | New Users to Excel | |||
Interrogating format | Excel Programming |