Forum Discussion
Need a count of *every* entry in a workbook
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.
Just a question for you: this is obviously a massive database, but in general (and I emphasize that, in general) you'll find we recommend creating a database in Excel as a single table, using a column or two to differentiate between entries. In fact, it looks as if you've already uniquely identified each row, such that even IF you were to put them all into a single sheet, you'd not even need to add a column.
And having all these slides in a single table would enable (I would think) far easier search and locate, easier overall summaries, easier over all database functions in general, than having to first find the unique tab and then search, summarize, whatever.....
So my question, which by now is obvious: What if anything precludes your putting all of these into a single table? There may well be a solid reason; I just (my consultant self) have to ask.
mathetes Because Excel doesn't like over 20000+ tabs in one workbook. And that is NOT an exaggeration. Also, I need to be able to add slides to a tab as I uncover more and more slide boxes. These have only ever been roughly inventoried, NEVER organized beyond cursory attempts. The final database may be in Access, though IT may want it in SQL. This is just the raw data entry step.