I have to do a lot of accounting where I type up bank statements and then have to sum up the activity by the reason. I was wondering if there is a way I can make a macros that will sum how much is under each category. I know that I can do If cell (i,2) is "Taxes"... but there is always a different category so I was wondering if there is a way for the macros to detect the different categories and sum them on the next workbook.
I made an example of what I would like the macros to do attached
Thanks!
Example.xlsx
Bookmarks