Forum Discussion
How to populate name in cell on excel calendar when date entered on sheet
Is there a way to auto-populate the name from a column on an excel sheet into the corresponding date on the excel calendar based on the date entered in a different column on the sheet? For example, on sheet 1 there are names listed in column A and appointment dates listed in column H. Each additional sheet is a monthly calendar template. I need the name to auto-populate on the calendar based on the date entered in column H. Also, there could be multiple names for each date.
See the attached demo workbook. I didn't create a full calendar, but the formulas used on the January sheet should give you an idea.
5 Replies
See the attached demo workbook. I didn't create a full calendar, but the formulas used on the January sheet should give you an idea.
HansVogelaar thank you so much! I collaborated with a coworker this morning and we were able to find this same type of formula on the web. I am saving your version in my notes to use for later!
peiyezhu I do not understand what you are asking? The link you provided is not the issue I am having.
Sorry,I do not understand what you are asking too?
I just guess.
