I have 13 worksheets, 1 for each month and a year summary.
Each worksheet uses column A to list each indiovidual day eg. 1st Jan,
2nd Jan etc. Column O is to indicate holidays taken so this will only
be blank or have a 1 in it. What I want to do is on the summary sheet I
would like to be able to list the dates that have a 1 in column O on all
the other worksheets. Is this possible and if so how?


--
Reefaman
------------------------------------------------------------------------
Reefaman's Profile: http://www.excelforum.com/member.php...o&userid=31968
View this thread: http://www.excelforum.com/showthread...hreadid=519640