Forum Discussion
Drop down lists
Placebow52 I suggest you could convert all raw data on each sheet to Tables and name them "CC1", "CC2", etc. Then insert some columns to the left of the raw data table on each sheet to create a Pivot Table with Categories are Row fields, or if you really want Categories in a drop down just choose Categories as Report Filter in Pivot Table instead. You will then use Refresh All to refresh all your pivot tables to display the most updated data.
However, if I were you, I would create a Master Tab which shows you the summary of each CC for each Category. Please see a simple version of this suggestion attached.
hynguyen Thanks for the info. I think it is too far beyond my ability however. Each of my sheets in the folder are like the running balance in you check book file. I want to make a list that will tell me each month the totals for a few of the places where I have bought things. For ex: Charity; Groceries. Thanks anyway.