I'm getting my butt kicked trying to create a formula to count instances across various worksheets.
I have a macro that inserts a clean template worksheet between a "First" and "Last" worksheet tabs. This template worksheet is then renamed from "Template (2) or (3....) based on the user input. Cells A9:A36 of these inserted templates have a drop down list of issues for the user to select.
On separate tab, I want to count the occurrences for each of these drop down items. The issue that I'm having is how to count them when I don't have a predefined tab name for these inserted templates. I'm not able to pre-name these inserted tabs because they have to be named after a job number.
Is there a way to write a formula that can read between the first and last tabs, and not specific to a named worksheet?
I have a macro that inserts a clean template worksheet between a "First" and "Last" worksheet tabs. This template worksheet is then renamed from "Template (2) or (3....) based on the user input. Cells A9:A36 of these inserted templates have a drop down list of issues for the user to select.
On separate tab, I want to count the occurrences for each of these drop down items. The issue that I'm having is how to count them when I don't have a predefined tab name for these inserted templates. I'm not able to pre-name these inserted tabs because they have to be named after a job number.
Is there a way to write a formula that can read between the first and last tabs, and not specific to a named worksheet?