The Next Level Technologies
Excel Learning...Read & Share....Happy Learnings
Record Macro (Automating day to day activity reports)
-> Choose Record Macro in the Code group of the Developer tab or View tab. ...
-> Type a name for the macro in the Macro Name text box. ...
(Optional) Assign a Shortcut Key. .
-> Now record the activity of the report
-> Once you have done with the recording Stop the Record where you have selected the start option
-> Test the record macro by giving shortcut key before you assigned
Contact us for complete Excel learning if you are interested.