Hi!
I have a workbook that i would like have a macro to move completed work (Column P= "Yes") on dispatch sheet and move the entire row to the completed work sheet.
I would like the completed work sheet to use relative reference so that the data will compile as it is completed.
On the dispatch sheet I would like the empty rows to be deleted so i do not have any empty rows between data.
Can someone please help.
I would also like to use one command button to do this task.
Spreadsheet attached.
Thanks so much in advance
Jackie
Bookmarks