i made a report in excel i used a command button in sheet1.
I want a syntax to my command button that transfer to another sheet with same as sheet1. automatically change the date or using input box i will change the date.
for example if i click the button the msgbox will appear and it will display a message "add Date?" if i click ok button the input box will run.