V
votequimby
I'm working on a monthly budget/check registry spreadsheet.
What I want to do is have the check register link to the allowed
balances in the monthly budget. I have two fields in my monthly budget
for each item. A projected cost and actual cost. I want to link
entries in the check registry to the actual cost of the fields in the
monthly budget. I plan to use account numbers to link these fields to
each other.
For example . . .
Say I buy groceries for $50. When I enter this into the check registry
I enter all the necessary information along with an account number that
links this transaction with my groceries actual cost field in my
monthly budget spreadsheet.
Is this possible? I plan on having 20 unique IDs/Account numbers.
What I want to do is have the check register link to the allowed
balances in the monthly budget. I have two fields in my monthly budget
for each item. A projected cost and actual cost. I want to link
entries in the check registry to the actual cost of the fields in the
monthly budget. I plan to use account numbers to link these fields to
each other.
For example . . .
Say I buy groceries for $50. When I enter this into the check registry
I enter all the necessary information along with an account number that
links this transaction with my groceries actual cost field in my
monthly budget spreadsheet.
Is this possible? I plan on having 20 unique IDs/Account numbers.