Dave,

Again it works terrific. Many thanks!!

From the new smaller dataset (all the extractions through red color) in
the new worksheet, I'm wondering if it might be possible to add this
step:

- take all of the data in the first four columns under the field
headings "city", "store", "product", "year"
- go to worksheet in workbook called "all data" and using this data as
criteria (field headings: "city", "store", "product", "year"), run an
advanced filter to extract all the data meeting this criteria from the
larger dataset called "all data".
- put this extracted data in a separate newly created worksheet
- put a protect on the newly created worksheet with the extraction from
the advanced filter, so that it can only be altered through password
(any password ok).

There are about 10 field headings in "all data", so the filter would
have to look specifically for all datalines meeting only the four
criteria "city", "store", "product", "year".

I hope this isn't becoming too extravagant, would be great if this step
could be added. Looking forward to your suggestions.

Dave Shapiro






*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!