Excel Moving a row to another worksheet

December 2, 2010 at 19:15:17
Specs: Windows Vista
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?


See More: Excel Moving a row to another worksheet

Report •

#1
December 3, 2010 at 10:38:07
There is no formula that can "move" a row. A formula/function can only return a result in the cell in which it resides.

You'll probably need to use VBA to accomplish your goal.

re: "one ordered confirmed i have a column confirmed i have a row that says Yes"

I don't understand this. Please try to explain it differently and we'll see if we can help.

Posting Tip: Before posting Data or VBA Code, read this How-To.


Report •
Related Solutions


Ask Question