Try this: In your db sheet, you could insert a new col A, then manually flag
the discontiguous rows quickly with an "x" (say). Once this manual effort is
done, just apply autofilter on col A, choose "x", then copy the entire sheet
n paste into another sheet. Only the filtered rows will get pasted over,
giving you the desired results.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Harvey" wrote in message
...
There lies the problem the criteria. I am selecting fields that match
another database that is not entered into excel I am selecting fields
manualy and I do not want to have do the same to extract the fields
individually to a second worksheet. I want to select the fields as a group
and copy and paste them to a second worksheet.
Harvey