I need to copy cells from one worksheet to another based on a text value held
in opne of the columns. The data is regarding late payments, so i have a
field "LATE?" which is either "LATE" "OK" or blank or N/A (ie other). I would
like to copy all of the rows that contain the value "OK" to a sheet called
"On Time" within the same workbook and all others ("LATES" and blanks etc) to
another called "LATE".

Any advice about how to do this would be great as I dont know any functions
that move cells and am unsure how I would go about it using VBA.