VBA Code to copy cell value on another sheet on drop down list changed

Hi,

I'm trying to create a calendar in excel that uses a drop down list to change month and year (Tasks sheet). Now what I want is for it to

1. automatically clear the cells on my calendar (Tasks sheet) once I changed the month or year -- already have the code for this
2. automatically copy my notes for each day on a different sheet (Tasks DB sheet) once I changed the month or year -- need your help with this as I don't have any idea on how I can do this
3. shows the notes of previous month if selected on the drop down. --Also needs help with this

Example of how the calendar works:
-----------------------------------------
Current month is June: Put my notes on the task I've done for the month as well as some comments. Then at end of month, I will change the month (select July on the drop down list). Upon month changed, all my notes for June will be saved on Tasks DB sheet and clear the Tasks sheet. Then if I want to review my task for the previous month I will change the month on calendar (set it back to June) and all my notes for that month will show again on the calendar.

I attached my calendar. So far, that is what I have. Thanks in advance for your help!

Hi mehmetcik,

I tried the calendar version 2, but it's not working..

The calendar is supposed to copy the month's notes to TasksDB sheet (to act as database). So that I can retrieve my notes (show on the calendar if I select the previous month on the dropdown) and clear the calendar (to refresh) if I select a new month (current month for the year). Do you have any suggestions on how I can make this easier?

Thanks,
aftermath09

Hi mehmetcik,

Task Calendar3 version is working perfectly. Thanks!

Can you also help me to display the following Holidays on their corresponding dates?

January 1 New Year’s Day (Regular holiday)
January 2 Additional special non-working day (Special non-working day)
February 19 Chinese New Year (Special non-working day)
February 25 EDSA Revolution anniversary (Special holiday for all schools)
April 2 Maundy Thursday (Regular holiday)
April 3 Good Friday (Regular holiday)
April 4 Black Saturday (Special non-working day)
April 9 Araw ng Kagitingan (Regular holiday)
May 1 Labor Day (Regular holiday)
June 12 Independence Day (Regular holiday)
August 21 Ninoy Aquino Day (Special non-working day)
August 31 National Heroes Day (Regular holiday)
November 1 All Saints Day (Special non-working day)
November 30 Bonifacio Day (Regular holiday)
December 24 Additional special non-working day (Special non-working day)
December 25 Christmas Day (Regular holiday)
December 30 Rizal Day (Regular holiday)
December 31 Last day of the year (Special non-working day)

Hi mehmetcik,

Thank you so much for all your help in making the calendar work.