I have 500 sheets in one workbook. They were created with a template so all cell references are in the same position on every sheet. I need to compile stats from the sheets. I have reports set up in another sheet of the same workbook. I need the reports to calculate the information in the other 500 sheets. For example: Report #1 compiles stats for the month of January from the 500 sheets, but I need it to ONLY compile that info from the sheets that have activity in January. So lets say I set a cell to have an “x”entered into it to indicate that this sheet has January activity. When that box has an “x” entered then the formula will compile the info needed from other cells in the sheet. If no “x” then ignore that sheet. How do I do that?
I will wait. I need to know how to do this.
never mind. I figured it out. maybe should cancel my subscription