Hello! When you copy the sheet over, you need to remove the sample data present. You can do this by highlighting all the green cells and pressing backspace.
Make sure not to highlight the grey cells when you do this. There could be formulas present that are needed.
Hi @1Email2RuleThemAll , thanks for this great sheet !
I want to use the statement purchases cell in the transaction sheet to enable me to automaticaly update the line i had for a future payment. I use the TAGS to calculate the cash flow required in the future month and adding credit card info helps a lot.
But if i try to point to the Crdit card spreadsheet column Q, i have #ref error, circular dependance and as well i need to multiply by -1 to get the negative result for the right calculation.
Is theyre a way to get a number that will update each time i download the transactions ?