I have an excel check register with sub-categories and categories that I need to know the sorted unique sub-categories by the calendar year. I'm currently using formulas but that's proven to run my CPU into the ground. So I did a bit of research and found some VB code on this site but I'm not able to get I to work as I need. If you open the attached file and take a look at what I have;
Here are the columns;
Here is what I'm trying to accomplish;
I'm certain someone can get me past this.
If I've left out any needed information please let me know.
Thank you
Here are the columns;
Date | DESCRIPTION | AMOUNT | NOTE | Sub-Category | Category |
1/2/2015 | CC:Misc | Deposit | |||
1/5/2015 | CC:Misc | Deposit | |||
1/5/2015 | CC:Misc | Deposit | |||
1/5/2015 | CC:1st Data | CC Fees |
Here is what I'm trying to accomplish;
Unique Sorted Sub-Categories used within the date criteria | ||||||
1/1/2015 | 1/1/2015 | 1/1/2016 | 1/1/2017 | 1/1/2018 | 1/1/2019 | 1/1/2020 |
12/31/2020 | 12/31/2015 | 12/31/2016 | 12/31/2017 | 12/31/2018 | 12/31/2019 | 12/31/2020 |
I'm certain someone can get me past this.
If I've left out any needed information please let me know.
Thank you