Look up value then determine group then copy group to different worksheet.

I am not really sure where to start or if I am posting in the correct area.

I have a big data set (33000 rows, 17 columns). I want to identify 4 different surface types (PCCPAV, PCCPDJ, PCCPOL, PCCUNF) out ~100. Those surface types correspond to LRS groups. Now here is the rub. I want to copy the entire LRS group that had a PCC* surface type (the rows) into another worksheet.

If it helps.
LRS =county number and state route number
beg = begin mile post
end=end mile post
len=length
Surf=Pavement Surface type

So I am trying to pull anywhere there was PCC* surface type then I want the entire County Route and I want to copy it to Sheet 2

There will be some LRS groups that have no PCC*

I found a simular thread http://www.excelforum.com/excel-prog...copy-rows.html but I got lost since I am needing to do a 2nd function of grabbing the LRS group.

I have attached an example spreadsheet.

Thanks for any help.