The workbook I've attached has three worksheets: 1) Open Orders; 2) To Be PU, Delivered, or Shipped; and 3) Completed. I need to be able to have a row in worksheet 1 move to worksheet 2 when the status in column 6 is changed to one of the following: to be invoiced, to be picked up, to be delivered, or to be shipped. Then the rows in worksheet 1 need to automatically move up to take up the now empty row. In addition, I need to have rows in worksheet 2 move to worksheet 3 when the status in column 6 is changed to "completed" and the empty rows in worksheet 2 to move up.
I have been working with the macros for a few days now and can't work out the problems. I would greatly appreciate it if someone could give me some help. I have attached the workbook.
Thanks for reading!
Bookmarks