I am attempting to create a workbook which will contain transactional data organized by month. Each month is contained in a separate tab within the same worksheet. I am adding a 'category' defining the purpose of each transaction. For the purpose of the spreadsheet, these categories should be reproduceable for the purpose of aggregating information by category. There are about 30 unique categories.
How can I get Excel to 'remember' these categories so I don't need to retype them every time I add transactions? Superficially, it appears as though characters are 'remembered' only if they have been entered on a particular sheet - eg, there is no 'cross memory' of entries from other sheets.
This is strange. Any clues as to how to accomplish this?
Bookmarks