The following formula has worked for me - good luck!

=IF(Sheet1!$B4=1,Sheet1!A4,"")

Assuming that the column headings are the same on each sheet and are in
the same row on each sheet:

Substitute "AlphaRoster" for Sheet1 - the criteria column and criteria
for B4=1

Enter the formula into the first cell below the columnA heading in each
worksheet and then copy it into the each column. Then copy that row
into the as many rows as you are going to need to use - more if you are
going to be adding more enteries.

Each sheet should display only the matches from your criteria, and
blank rows for the rows that do not match. Then "Data-Filter" each
worksheet to filter out the blank rows.

Each time you change the criteria on the AlphaRoster you will need to
re-filter the affected worksheet. Small price to pay.

I'm not an excel guru - far from it. Butcher is more fitting - but it
works for me. I do hope it helps you until someone shows us the proper
way.

Dean Thomas


--
Lost4Now
------------------------------------------------------------------------
Lost4Now's Profile: http://www.excelforum.com/member.php...o&userid=29345
View this thread: http://www.excelforum.com/showthread...hreadid=495964