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

Pete

On Mar 10, 12:11 am, 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