Calendar from Excel Data
Calendar from Excel Data
(OP)
I have a list of jobs with due dates in an excel file. I want to take the data and make it into a normal looking Monthly calendar. I can find lots of templates for excel calendards that look good. But my question is how to integrate the two.
My first thought is to use the LOOKUP function. And that would appear to work, but I almost have to start over and make my own calendar. Is there a smarter way to do this?
I guess I am just wondering if anyone has already done this and could send me a sample I can modify. I did a quick search of the forums and the web, but did not find a ready made solution.
Thanks, M
My first thought is to use the LOOKUP function. And that would appear to work, but I almost have to start over and make my own calendar. Is there a smarter way to do this?
I guess I am just wondering if anyone has already done this and could send me a sample I can modify. I did a quick search of the forums and the web, but did not find a ready made solution.
Thanks, M





RE: Calendar from Excel Data
RE: Calendar from Excel Data
Please let us know what you figure out, if you have any luck with it.
RE: Calendar from Excel Data
RE: Calendar from Excel Data
Insert->Object->Calender Control.
This will add ActiveX object to your sheet. How to use it further, I don't know. You can do some research on this. If you do, please don't forget to share your findings with us.
Ciao.
RE: Calendar from Excel Data
Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting
UK steam enthusiasts: www.essexsteam.co.uk
RE: Calendar from Excel Data
My preference would be to just have a second excel sheet in the same file with the calendar. Simple as possible really and completely separate from outlook. It would just use standard excel functions/formulas to update the second sheet.
flamby's idea of insert->Object->Calender Control sounds like a good idea. I guess I will have to find some free time and just make it myself. I will let everyone know what I figure out.
RE: Calendar from Excel Data
MS project doe s pretty good job with what you need and you should be able to pick up a legal version for $200.oo. If you hourly rate is $80 you can only spend 2 to 3 hours for a program that will be hard to keep yor software up-to-date every time Microsoft releases a new version of Excel, Calendar ActiveX and so on.
Copying you spreadsheets to MS project is easy.
Sometimes it is worth to spend some money.
RE: Calendar from Excel Data
I did create a preliminary versions for those of you who are interested. It lets you have up to three items happen on the same day and lets you choose any month to look at. Just need to make sure that you sort your projects by due date for the calendar to work.
I will post it at the following site for a month or so:
http://st26.startlogic.com/~montanab/TEMP/
RE: Calendar from Excel Data
Thanks for your help.
RE: Calendar from Excel Data
http://www.ozgrid.com/Excel/DynamicRanges.htm
Lots of interesting applications at this site.
Regards, M