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? |
Interrogating Data on Hidden Sheets
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? |
All times are GMT +1. The time now is 03:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com