IF Than to copy entire row to new worksheet.

[calberttj]

I have awesome form that i am using for our company that is simple. it just helps keep track of the status of our orders. what i am trying to do is create some sort of formula to "copy" contents from one worksheet to another given the right variables match.

here is what i have.

sheet1; DASHBOARD
sheet2; AWAITING ACK
sheet3; AWAITING DELIVERY
sheet4; COMPLETE
sheet5; ATTN REQUIRED

in each sheet row1 is:


STATUS | PO | VENDOR | CLIENT NAME | PROJECT # | SALES PERSON | ORDER DATE | SHIP DATE | CARRIER | TRACKING | ARRIVAL DATE

in sheet1 its and overview of all orders. regardless of status

each sheet following should match to the status;

sheet1; DASHBOARD = [ALL ORDERS]
sheet2; AWAITING ACK = "ORDERED"
sheet3; AWAITING DELIVERY = "ACKNOWLEDGED", "SHIPPED"
sheet4; COMPLETE = "COMPLETE"
sheet5; ATTN REQUIRED = "ATTN REQUIRED", "PROCESSING"

so now that the details are laid out. here is what i am looking to do.

when i create a new row in the dashboard. and start filling out the columns. depending on what status i put i would like it to "copy" or show on the respective sheet.

so if i made a row and put the status as "ORDERED", it would show on sheet1, and also sheet2. and if i were to go into either sheet and see that row and update the status again, it should move again to it's respective sheet.

i am currently using google docs for easy sharing and easy access.

please let me know if anyone can help! it would be greatly appriciatted.

here is what i tried. but failed;

Please Login or Register  to view this content.

If you would like access to the document let me know.