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
One store (tab) might say
Another store (tab) might say
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.