Here's what I'm trying to figure out how to do: I have an excel calendar that I basically use to track my spending. I manually enter my spending every week or two into the calendar and I pretty much have an overview of what my account balance will be at any given day of the month based on spending that's occurred and projected income (ie paychecks).
This is kinda cumbersome when I skip a few weeks and have to go in and enter a month's worth of stuff.
Is there a formula, function, script or something that I can use to work with the following workflow:
-Export my transactions from my bank account into CSV format. -Paste those transactions into a sheet (Transactions) of an excel file. -Have the formulas already loaded into the calendar sheets that will automatically pull the transaction data from the Transactions sheet and populate them into the appropriate dates on the calendar.
My thinking is that there should be a way for a formula to read a sheet for Date/Dollar Value/ Description and place the Dollar Value & Description into the appropriate Date on the Calendar sheet.