Thank you for the response!!!!!! Its really helpful...
Can you please do me a favor if you could attach a file that would be helpful.
John, Please suggest me another macro because If I want to change the day to Tue,Wed,Thur,Fri instead of Monday it will be helpful.i
and John its giving me below error when ever I save the file after writing the Macro.
The following features cannot be saved in macro -free workbooks:
To save a file with these features, click No, and then choose a macro -enabled file type in the File Type list.
To continue savings as a macro -free workbook, click yes
When I say No then the macro which I have written its not getting save. Please advise which settings I have to change in my excel file. And I'm using the Excel 2010.
Thank you again and again!!!!Your really doing a awesome job by helping every one here!!!!!