how to select only specific rows corresponding to a specific value in a column

hello everyone,
i have this big problem. i would like to run a macro for this purpose: i have an excel sheet like this:

COLUMN A COLUMN B COLUMNC
2001018 C 30000
2001018 P 28000
2001018 P 30000
20010218 C 25000
20010218 P 25000
20010218 C 27000

i want to run a macro, that in correspondence to a data like 20010118 selects a row containing a C and a row containing a P but both of them must have the same value in column C. in this example for 20010118 i want to be selected only first row and third row.
" to be selected" i mean to open a new worksheet with the selected rows.

many thanks

Try this macro:

Please Login or Register  to view this content.

This macro assumes that you have headers in row 1 of the sheet where your data is located and the data starts in row 2. Change the sheet names in the code to suit your needs.