Raja Kamarthi
New Member
Hello Friends,
Am working on a daily report template and looking out for scripting assistance to complete this task. below are few requirements which need to developed
1) A macro to create a copy of the active sheet but the new sheet should carry blank for cells:D4, D7, D8, D9 likewise till D16 & D18
2)When the user selects any date from the calendar in the sheet, the same date should be reflected in D4 cell i.e I select 5th July in the calendar, now D4 cell should show the same date and also the selected date cell in the calendar should get some format like cell filled with yellow or blue colour, just to highlight the selection of the date
Please access the below link for more details
https://www.dropbox.com/s/8nv2prkz022sxru/Daily%20Report.xlsm
Thank you in advance and looking forward for your support
RK
Am working on a daily report template and looking out for scripting assistance to complete this task. below are few requirements which need to developed
1) A macro to create a copy of the active sheet but the new sheet should carry blank for cells:D4, D7, D8, D9 likewise till D16 & D18
2)When the user selects any date from the calendar in the sheet, the same date should be reflected in D4 cell i.e I select 5th July in the calendar, now D4 cell should show the same date and also the selected date cell in the calendar should get some format like cell filled with yellow or blue colour, just to highlight the selection of the date
Please access the below link for more details
https://www.dropbox.com/s/8nv2prkz022sxru/Daily%20Report.xlsm
Thank you in advance and looking forward for your support
RK
