Need to create a new list in a new worksheet with only certain lines from original.

Hi guys,

Not sure how best to phrase this..

I've got a spreadsheet with a long list of couriers and costs. I want to generate another worksheet with only entries for those in the original sheet who match a certain courier, so I end up with a pre-filtered list of couriers.

Eg.

DHL £25
DPD £35
DHL £11
UPS £15

in the second sheets becomes (when selected for DHL) just

DHL £25
DHL £11

So all the other entries are omitted. My original spreadsheet is 40000+ lines long, so a condensed list makes working with it much easier.

Any ideas?

Thanks

Bob