Linking workbook info to excel calendar
 

I am still working on my project and have one last function to add.
I have two cells within my "Job Template" workbook. One contains a
€œtemplate date€� and the other is the €œinstall date€�

I would like a formula, macro, etc that will €œexport€� to an excel calendar
(I downloaded from
http://www.vertex42.com/ExcelTemplat...-template.html ).

I would like to export €œTemplate €˜job name€� into the appropriate date as
well as €œInstall €˜Job name€� into the appropriate date as well. Separate
colors for each would also be nice.

If anybody has any input I would appreciate it.

Steve