If row 1 and row 10 met your criteria, would you want the copy to appear in
row 1 and row 10 of the destination sheet or row 1 and 2 of the destination
sheet?
--
Gary''s Student


"jackle" wrote:

I have a co-worker that would like to make a feature in EXCELL that would
select a non-contiguous series of rows based on a specific character (like a
!) in column. Then he would need to copy that into a new worksheet in the
same spreadsheet.. I am used to MS ACCESS, which is a snap due to tables and
queries that can work inside Access. Worst case scenario, it can be done in
Access and read from the Excel worksheet. But Id like to see how it can be
done in EXCELL. Any Ideas? Since I am not well-versed in EXCELL, you may need
to be specific. I do understand some things though. Thanks in advance.