How do I add text to worksheet page based on intuitive formatted d

[Guest]

This may be pretty tricky but I am pretty sure can be done.
I have a worksheet formatted as a calendar, it looks like one month at a
glance but all months are on the same sheet (2007). Each "box" that
represents a date is one column wide but 5 rows high. ie. Jan 14th box is =
b16:b20 Nov 10th is = h519:522

I want to be able to take 5 other worksheets in my book and input a
formatted date (ie. 1/14/07) in column A and then input highlighted text in
column B (ie. install routers) I want the text (with the highlighted yellow)
in column B to go to the appropriate spot on one of the rows of the calendar,
I'd like to be able to do this w\ each of my worksheets (even if I need a row
for every variable in the calendar) but taking multiple project dates and
having one master calendar.

FYI, I know I can do a direct = cell Calendar!A18 but I am looking for
something intuitive as dates typed in will be at random and out of order on
my 5 worksheets. I'm looking for excel to automatically know when I type in
formatted date :1\14\07 to know which cell that is equal to on my calendar.

Any help is much appreaciated!

 

[Dave Peterson]

Without answering your question...

You may want to look at the way Chip Pearson approached it:
http://www.cpearson.com/excel/download.htm
(look for Calendar)

It's different (dates aren't multiple cells--just sized bigger).

You may find using Chip's program even nicer than building from scratch???

 

[Guest]

Very close, but I'd rather have the flexability to add multiple worksheets
and to have 2 colors in a date cell (which means I would need mutiple rows)