Dynamic calendar and locking each month

[Liverlee]

Hi peeps.

I've come for your help and assistance again.

I followed this video on youtube regarding creating a dynamic calendar so you can flip from month to month, without having to use multiple tabs. Which i thought would be great.

The only issue i'm having is if a i enter data in any of the columns in the month of jan. So say the first of jan i put an x to mark the spot, if i flip to feb the x is still there on the 1st feb.

Any advice or guidance on how to lock the data to the month and still be able to flip from jan to dec?

This is the youtube video - hope its ok to attach the link
https://www.youtube.com/watch?v=S96V-43_hgc

 

[John_w]

You would need code which saved the task cells for every month (and year) in another part of the workbook, e.g. another sheet or cells below the calendar. This could be done with the Worksheet_Change event handler, so that when you type in one of the task cells the code saves the task cells for the currently selected month and year, and when you change the month and year it retrieves the task cells from the 'task database'.

 

[Liverlee]

You would need code which saved the task cells for every month (and year) in another part of the workbook, e.g. another sheet or cells below the calendar. This could be done with the Worksheet_Change event handler, so that when you type in one of the task cells the code saves the task cells for the currently selected month and year, and when you change the month and year it retrieves the task cells from the 'task database'.

Thanks John, i feared as much, so i need some code like vlookup or index/match.