I have come across your site through Google searches, and I need your Excel expertise to help me refine a few formulas to auto-populate an Excel Calendar from a Project worksheet. I have adapted an MS template and have used multiple resources to guide me, but I am stuck adapting some of the resources to accommodate multiple dates.
Basically, I would like the dates entered in the "Project" sheet to populate in the "Calendar" with the ProjectName and StatusHeading from the Project sheet. Also, If possible, I would like to avoid VBA and macros since the users are not always wise enough to enable them when the warning pops up on open.
Here are my issues on the Calendar:
1) I can't get any dates beyond Projects!C:C (25%) to show up. I get an N/A error.
2) I got an error when referencing the StatusHeading in the formula so I have created a nested IF. Hopefully, there is a better way.
3) I would like to copy the formula to Rows 8-11, etc. that adds something like IF B7=0,"", (ELSE I'm not sure how to write this part but when B7 and B8 match, then go to the NEXT 11/1/2015 date OR show the different new date OR leave blank if the previous criteria are not met)
On the Projects sheet:
4) I would like to write a conditional formatting formula that if the same date shows up more than 5 times, THEN the text turns red so the user knows it won't fit on the calendar.
Any help is appreciated. THANK YOU!
Here are some other resources I used to perhaps help:
http://www.excelforum.com/excel-general/949879-auto-populating-excel-calendar.html (excel_help1=Test1 Excel Calendar.xlsx)