I'm preparing one single table for multiple bank accounts. The table will be basic for pivot analysis, reports, etc...
The problem I have is that I would like to get new account balance at every new income/cost for each name (new rows, etc...) in one table. Because during the year the table will sure become huge (at least 3.000 rows), I need a solution as simple as possible to avoid excel being slow. I know how to make multiple tables for each account, but that means excel will become slow for sure...
Any simple ideas?sample.xlsx
Bookmarks