Team,
I have a large workbook, and am needing a way to create a "snapshot" of equipment at various locations. Example:
# Location Info Date Hours Driver
200 CRP 5/8/2013 250 Tim
201 Rig1 1/1/2001 500 Bob
202 Rig 2 1/1/2001 0 Joe
203 no data 1/1/2001 0 Nick

What I am needing is to be able to click "CRP", for example, and have it produce a report with all the information where CRP is the location. Sorting won't work as there are a number of merged cells used to separate equipment types.

There are over 100 different locations and we need a quick way to see what each location has.

Thoughts?