I'm not sure what you mean, but you can use an Advanced Filter to copy
the data to a different worksheet. There are instructions he

http://www.contextures.com/xladvfilter01.html

KCWCD190 wrote:
I am trying to copy data from one worksheet in excel to another. I only want
rows that meet a certain criteria--such as all customers in a certain
category. Is there any way to copy just the ones I want without filtering
the list before copying?
KCWCD190


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html