|I have 4 work sheets:|
worksheet one has pending orders
one ordered confirmed i have a column confirmed i have a row that says Yes
I want the information in that row to go to the next worksheet#2 which is on route to delivery. Once delievered I have a row that saids Yes
That row would go to the next Worksheet that states Delivered row with Yes to next work sheet for billing.
What is a formula to activate a whole row to move?