Need solution for multi criteria filter in excel

[rajaakku]

Hi Team,

I need your help for the below issue.

i have an excel which have 5,000 rows and 3 column (A,B and C) in "C"
Column i have a date "Cisco 7940" "Cisco 7941" "Cisco 7942" etc
i want to filter 7940 and 7942 model only from "C" column and paste
that filtered data into new excel i mean completely in new excel

i need a clear explanation since i am very new for excel macro and vb...

My contact number : + 91 8056083767.

 

[mikerickson]

I'm not sure what you want, but it sounds like Advanced Filter might do it.