Hi All,

I have an excel spreadsheet that lists every date in the year, with a
particular code in the next cell.

IE:
Monday 3/01/2005 11M 22M 32M
Tuesday 4/01/2005 11T 22T 32T
Wednes 5/01/2005 11W 22W 32W
Thursday 6/01/2005 11H 22H 32H
Friday 7/01/2005 11F 22F 32F
Saturday 8/01/2005 11S 22S 32S
Sunday 9/01/2005 11N 22N 32N
Monday 10/01/2005 11M 21M 33M
Tuesday 11/01/2005 11T 21T 33T
Wednes 12/01/2005 11W 21W 33W
Thursday 13/01/2005 11H 21H 33H
Friday 14/01/2005 11F 21F 33F

What I need is to be able to search by the code eg "33T" and have all the
dates listed for the rest of the year in a seperate sheet.

Also, (now I know I'm asking too much :0) but would it be possible to have a
pre-designed calendar set up, and the dates get automatically
highlighted/shaded with the dates listed from the search???

THANKS!!!!!!!!!!!!!!!!!

Nat