I have an excel file with about 50-60 workbooks inside of it each containing data.
I work for Albertsons and each tab is an individual store
For example:
One store (tab) might say
Crackers 4ft
Another store (tab) might say
Crackers 12ft
I want to go across workbooks and have it count how many stores use the 4ft set and how many use the 12ft set. I'm not sure if this is possible or how to even go about doing it. Any help would be much appreciated. Thank you.