How I can removed the Calendar that accidentally appeared in my worksheet?

List to calendar

• QUESTION: I have one worksheet that has a list of items in date order. The dates may repeat, so that several items occur on the same date. I have another worksheet that is set up like a calendar. I would like to be able to modify the schedule sheet and have it populate in the calendar under the appropriate date. I tried vlookup, but if there are 3 items on the same date, it only returns the last one in all cells looking for that date. I hope this was clear enough and thank you for your time. ANSWER: OK, good to know, I guess, So, what's your question then? ---------- FOLLOW-UP ---------- QUESTION: Thank you for the quick response. I would like to know how to link my list worksheet to my calendar worksheet so that any time I enter or modify the date in the list it will show up under the appropriate date in the other worksheet.

• Answer:

  You're welcome. You will not be able to do this with formulas, especially now since you have said that you want to do it any time you enter or change an item on the other sheet. You will have to write a macro and then setup the macro to run EVERY time you enter or change an item on the other sheet.