bundyloco,

Excel is so easy to use -- it's ALSO so easy to make mistakes.

One big mistake that I have observed many times over, is segmentin
data by a data element; in your case the data element is days of th
week.

More than likely, you and your organization/company, would be muc
better served by keeping your data together in a single table in you
Excel database.

In your case, the answer could be accomplished in any number of way
and far easier if ALL your data were in a single sheet.

I'd do a simple MS Query, using Data/Get External Data/New Databas
Query...

In the Query Grid, I'd set a Criteria on the Left(YourFirstCol, 1) wit
a value of 'Y'

There's no VB code required for this technique and the query wil
Refresh, returning results no matter how many rows of data ther are i
your source sheet.

Alternatively, if you can't or won't consolidate your data, the quer
can be written as a UNION of the 4 sheets, using the same criteria i
each Select

--
SkipVough
-----------------------------------------------------------------------
SkipVought's Profile: http://www.msusenet.com/member.php?userid=198
View this thread: http://www.msusenet.com/t-187051396