Cross Reference Report - Workaround Ideas
I know that I cannot cross reference a report; I'm hoping someone might have an idea on a workaround.
I have a report that gathers data from all sheets in a specific folder. The quantity of sheets varies around +/- 200.
I want to get one summary field (to match on) and the sheet link from each sheet into another sheet. I do not want to retain data from sheets that are completed and deleted.
Any suggestions other than having the sheets copy a row to another sheet, which would need a method to remove data that has been completed/deleted?
Help Article Resources
Check out the Formula Handbook template!