Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
mcboots
 
Posts: n/a
Default Linking dates with a calendar...

My hope is this...

column A are names of those I have scheduled meetings with.
column B is a date I enter with the next several columns auto filling using
a function.

I would like to link this to a worksheet with a calendar so it displays the
persons name on the calendar on the dates that the worksheet has listed (5 or
6 each person). Thank you for your help.
  #2   Report Post  
scasawyer
 
Posts: n/a
Default

If you create a calendar in excel then this would not be a problem, what
kind of calendar are you planing on using

"mcboots" wrote in message
...
My hope is this...

column A are names of those I have scheduled meetings with.
column B is a date I enter with the next several columns auto filling
using
a function.

I would like to link this to a worksheet with a calendar so it displays
the
persons name on the calendar on the dates that the worksheet has listed (5
or
6 each person). Thank you for your help.



  #3   Report Post  
mcboots
 
Posts: n/a
Default

i am using the template from microsoft of 2004 and 2005 on a single worksheet
though i might have to put each year on its own worksheet... is that a
problem?

You say its not a problem? example:

1a 1b 1c 1d 1e
jeff 24july04 24Aug04 autofilled/date autofilled/date

so on the calendar on each date in 1b-1e you would find the name Jeff... if
this is easy to do can you also include the column label also? Each column is
labeled for a specific meeting topic... thanks for your help

"scasawyer" wrote:

If you create a calendar in excel then this would not be a problem, what
kind of calendar are you planing on using

"mcboots" wrote in message
...
My hope is this...

column A are names of those I have scheduled meetings with.
column B is a date I enter with the next several columns auto filling
using
a function.

I would like to link this to a worksheet with a calendar so it displays
the
persons name on the calendar on the dates that the worksheet has listed (5
or
6 each person). Thank you for your help.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Ploting dates against a calendar and not as a simple events Barb Reinhardt Charts and Charting in Excel 2 January 22nd 05 02:41 AM
Formating Dates for production schedule dpl7579 Excel Discussion (Misc queries) 1 January 11th 05 08:43 PM
due dates Niki New Users to Excel 4 January 10th 05 04:11 PM
Calendar and info for that date Jenn Excel Discussion (Misc queries) 0 January 5th 05 04:21 PM
have dates entered from a list of data into an excel template Diane Excel Discussion (Misc queries) 1 December 28th 04 06:33 PM


All times are GMT +1. The time now is 07:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"