Thanks Max it worked, I knew there had to be a workaround to do this task.
This makes my job much easier.
Harvey




"Max" wrote in message
...
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