|
| yes, I've used one. I put my check info to the left side, make a column for determining which category I want the expense or income to go in, and then make as many categories/columns as needed using =if statements to direct the expense or income to the correct column. One sheet per month, then drill down the monthly totals to a summary sheet for a yearly summary and tax sheet if wanted. You could then copy all your transactions to a blank sheet and do a sort and data summary to get all of the expenses throughout the year listed by category. | |
|
Anyone use Excel to make a checkbook registar?
