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 segmenting
data by a data element; in your case the data element is days of the
week.

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

In your case, the answer could be accomplished in any number of ways
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 Database
Query...

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

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

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


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