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!

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???

Britt wrote:

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

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)

"Dave Peterson" wrote:

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???

Britt wrote:

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