Formula to auto populate Calendar

[kh2733]

Good Morning,

I recently stumbled accross this website while trying too look for a formula to auto populate daily events on a spreadsheet. I must say that this forum is amazing. Well done everyone.

I used - ef89_scheduler.xls found on http://www.excelforum.com/excel-prog...html?p=2768117

This formula works great for some months but when i view a few months the formula result is not displayed unless i click and highlight the cells.

Any idea why the info would be 'invisible'??

[Pete_UK]

Attach the file as you have amended it, and I'll take a look.

Pete

[kh2733]

Thanks Pete!

September, October work ok but November isnt working

[popipipo]

Delete all the conditional format and all works fine

[kh2733]

Still cant get Feb 2014 to work

[popipipo]

I have changed the formulas in row 2

[mja ouryclark]

Hi All
How do you change the years the sheet covers?

Thanks
Martin

[JohnTopley]

Click on AF5 then "Data Validation": you will see years listed.

(but this thread is nearly 4 years old!!)

[mja ouryclark]

Still a nice piece of code!
Thanks
Martin

[JohnTopley]

Agree! thanks to Pete_UK (the author).

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[Pete_UK]

John,

that poster is not the originator of the thread, so he can't mark the thread as solved.

Pete

[JohnTopley]

...so can it be marked as SOLVED by a moderator?

[mja ouryclark]

Click on AF5 then "Data Validation": you will see years listed.

(but this thread is nearly 4 years old!!)

Are you sure it is in Cell AF5?
Thanks

[JohnTopley]

Click on AF5 then "Data"==>"Data Validation" where you will see the years listed in "Source": change entries in "Source:".

[Pete_UK]

... Are you sure it is in Cell AF5? ...

If you are using either of the files from Post #3 or Post #6 then it is cell AF5 that contains the drop-downs for the years. If, however, you are using the file from the thread pointed to in Post #1 (i.e. ef89_scheduler), then the years drop-down is in cell Z5. I've posted several of these calendar files over the years, with slight variations depending on how much data the OPs want to display, so the drop-downs may appear in different columns.

Hope this helps.

Pete