Many many thanks to Chip Pearson for his help on Nov
28...but as usual developers don't tell users much about
the application. Here is what is happening -

I use a workbook with 8 worksheets. This workbook is used
by many diferent departments so I cannot modify it. The
first worksheet (Summary)is populated with information
such as store number, store opening date, store owner,
etc. There is another worksheet (Addresses) that has all
of the address information. Thanks to Chip, I have the
code that will query the Summary worksheet and give me a
list of all stores opening between two dates. Now I need
to query the Addresses worksheet in order to get the
address information. There is a common "key" (store
number) in all of the worksheets. Is there a way I can
grab this "key" and use it to query the address worksheet
so I can grab the address information?

Any and all help is greatly appreciated.