G
Guest
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?
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?