Data Validation For Selecting Date And Week Number

[paul_pearson]

Hi Excel Fox

I think the best solution would be for me to enter a date into cell C15 and then through VBA select a button and it inserts the dates through to 21/12/2013 using the pattern of dates in the file attached.The week numbers would also insert with VBA according to the date....I would also have a second button which deletes the dates but only after a password is entered........I would then change the code when this spreadsheet is used for 2014 onwards

Maybe you could also achieve this with a dropdown list (DV) which I would prefer but I do not know if achievable

Thanks Venkat

Thank you

Paul