I have Excel 2007 and I need help to move data from sheet1 to sheet2 and deleting data from sheet1.
I have worksheet1 with customer, production, shipping etc. Once an order has been completed I want to delete if from sheet1 and transfer the information to sheet2 so that I have an ongoing record of what was completed. The first 3 rows are a frozen header and I’m using columns A thru AA, and rows 4 thru 3000. Upon completion of an order I would like to place an “x” in column A and have the transfer take place, moving all remaining data up to fill the deleted cells and placing the transferred data on sheet2 by moving all previously transferred data down one row and placing new transferred data into row 4.
Bookmarks