Split Credit Card with Partner

Google Sheets
,
21

Hey Randy,

I’m trying to follow your advice. Is the A04 cell you’re referring to the one with the year pulldown menu? If so, how might I change that so that it points to the Personal Amount column without sacrificing it’s utility as a filter for the year?

Thanks!
Zachai

1 Like
22

After you have created a “Personal Amount” column in your Transaction sheet like in car32michael’s sample sheet, and you want to point the Monthly Budget and Yearly Budget sheets to point to your Personal Amount column, you need to update the hidden cells that provide the new column address.

  • Monthly Budget: change “Amount” to “Personal Amount” (or whatever you’ve named your new column). In the sample sheet, that’s in J27, and the formula in K27 will now return “F”.
  • Yearly Budget: Change “Amount” to “Personal Amount” (or whatever you’ve named your new column). In the sample sheet, that’s in A04, and the formula in AP4 will now return “6” and AQ4 “F”.

(note: specific cell addresses above are based on the sample sheet. If your sheet has additional new columns, addresses will be different.)

2 Likes
23

thanks for providing a solution here @brettanicus