Filtering Data

[Guest]

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

 

[Pete_UK]

It's ironic that you have "Filtering Data" as the topic and then ask
if you can do something without filtering !!

Pete

 

[Debra Dalgleish]

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 here:

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