vestax22,
Another option... Excel menu: Data - Filter - Advanced Filter.
Using VBA and the "Advanced Filter" it's fairly easy to extract a copy of the precise data required - to a separate sheet.
By setting up "criteria" for the extraction, one can be VERY specific in identifying the precise data you require extracted. The criteria can be as simple or as complex as is required - i.e. multi-fields can be referenced, with multi-conditions.
A "bonus" - The Advanced Filter is a "custom" (internal) component and is written in the same C language as Excel. This makes it MUCH faster than other options such as looping through data using VBA looping routines.
What you've described is fairly simple to set up, but ufortunately, Microsoft's documentation on the Advanced Filter is less-than-adequate, and without help it could be a bit of a struggle.
If you would like to email me a scaled-down version of your file (just a handful of records - with any sensitive data replaced with fictitious data), I'll set up the file and get you "jump started". It will be set up so that all you'll have to do is "click a button" to extract a copy of the exact data required, to a separate sheet.
Hope this helps.
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
