|
Leesport, PA | I am trying to figure out if Excel can do the following.
I have one worksheet that is my personal checking account. In it I enter my various transactions. I would like it to also automatically carry some transactions over into other worksheets in the same file. Clear as mud? Here is an example of what I mean.
Lets say that once a month I write a check for my car payment. I enter this transaction into the checking account worksheet. I also would like to keep a total of my car payments in a separate worksheet. Is there anyway to automatically feed the transaction from my checking account balance worksheet to my total car payments worksheet? I visualize having a "code" column in my checking account balance where I enter a number (like "1" for car payment) that would signal Excel to copy that line into the next available line of the total car payments worksheet.
I had thought an "if, then" function" might work but after looking that situation over I don't think it will.
Thanks for any suggestions you have to offer.
Ryan | |
|