I have multiple rows of order data need to move daily to completed order tab

art69

New Member
Joined
Feb 27, 2015
Messages
6
I want to use column A if there is a number 1 in column A the order is complete and needs to be moved to the last empty row in the completed order tab. I just need a macro to move all completed orders once a day and clear the data that as been moved and move all other rows left to the top of the list.
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,515
Office Version
  1. 2013
Platform
  1. Windows
Have you typed "move rows" in the Search box ?
There are a significant number of responses
 

Watch MrExcel Video

Forum statistics

Threads
1,119,247
Messages
5,576,935
Members
412,753
Latest member
Coach_Olson
Top