Forum Discussion
Solved
Need a count of *every* entry in a workbook
So I'm using Excel to create the framework for a catalog of a glass slide collection. One spreadsheet alone has nearly a hundred tabs, all named uniquely with an abbreviation of the slide name, each ...
If you can live with a quick-and-dirty solution by adding two empty sheets "first" and "last", have a look at the attached file. I entered a few formulae in the "-Legend-" tab.
Ideally, I'd like something that *wouldn't* require naming every single tab in the formula. This is basically so we can get a better idea of just how many individual slides there ARE. Excel's already starting to choke on the largest file, which is uploaded below. (And I'm still adding to ALL 27 files!)