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?

Hi
I'm not sure what you mean by saying that the macro can't find the
sheets. One possibility is that you are using something like
Activesheet.Range("a1").Autofilter

and since the sheet is hidden it can't be active.
If this is the case use the worksheet name instead
Worksheet("mysheet").Range("A1").Autofilter

only thing I can think of without seeing some code.
regards
Paul
PS Note that very few questions get answered that don't contain some
code to go on.

On Mar 9, 4:49 am, D Zandveld
wrote:
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?