Copy and Paste with an IF statement?
I need to know if it is possible to set an IF statement that will essentially copy and paste an entire row's entry into another table when the IF statement is true.
I am trying to create a very in depth financial spreadsheet, and the goal of my request is to enter a transaction once, and it shows up in the other account as well.
I have my "Checking Account" as one Sheet, and my "Credit Card" as another Sheet. I want to enter a credit card payment into the Checking Account transaction list, and then have it automatically add the transaction to the Credit Card.
In the Checking Account Transactions table, I have a Pop-Up Menu created and "Credit Card Payment" as one of the choices. My idea was to use an IF statement somewhat like SUMIF, but not necessarily SUM. This is my thought process, but I'm not sure how to write it for Numbers to perform the action, if it's even possible...
IF({Checking Account Sheet}{Transactions Table}{Category Column} = "Credit Card Payment" (as text string from pop-up choice), then copy and paste this row into the next available row in "Credit Card" table)
Now, I also have more than one credit card account, so to take it even a step further, in the Checking account transaction, I want to specify a "To Account" within the row for that transaction, and then have it paste to the correct credit card sheet:
Checking Account - Sheet 1
Credit Card 1 - Sheet 2
Credit Card 2 - Sheet 3
IF({Checking Account Sheet}{Transactions Table}{Category Column} = "Credit Card Payment" (as text string from pop-up choice), then copy and paste this row into the next available row in {sheet that is named "Value of [To Account Column]"}{Transactions Table})
or, for a checking account transaction that is a credit card payment to Credit Card 2
IF({Checking Account Sheet}{Transactions Table}{Category Column} = "Credit Card Payment" (as text string from pop-up choice), then copy and paste this row into the next available row in {Credit Card 2 Sheet}{Transactions Table})
Obviously the Parentheses and brackets and such are not the correct syntax for what I would need to do, hopefully I'm getting across what my intentions are with this request for assistance.
Like I said, I'm not even sure that this is possible, but any assistance to help me with this issue would be greatly appreciated!
Thanks so much.
-Brevig
iWork '09 (Numbers)-OTHER, OS X Mountain Lion (10.8)