Hi all
I have a worksheet that I would like to move the contents of a row to another sheet based on the cell content in column 'K' = "yes", effectively archiving any jobs that have been invoiced. A VBA code that I can attach to a form control button would be ideal.
A sample spreadsheet has been attached so any help offered would be appreciated.
Thanks Phil