1) create 2 new sheets called On Time and Late. (Right click on the sheets
at the bottom, choose insert worksheet, then do it again but choose rename).

2) go back to your original list. select all the data and do Data Filter
Autofilter

3) use the little arrow on the column you are interested in to filter for OK

4) select all of these and do ctrl-C (copy)

5) select the sheet called On Time, do right-click in cell A1 and do paste
special values then do it again with paste-special formats

6) go back to your original sheet. now on the filter arrow choose custom.
choose "does not equal OK"

7) select the sheet called Late, do right-click in cell A1 and do paste
special values then do it again with paste-special formats

8) (cheeky one this) very important, come back to this website, click on
this message and give me a green tick

HTH

--
Allllen


"oli merge" wrote:

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.