98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Macros
Macros
Resolved · Low Priority · Version Standard
Amanda has attended:
Excel Intermediate course
Excel Advanced course
Macros
How do you set up macros for data reports I put together frequently?
RE: Macros
Hello Amanda,
I hope you enjoyed your Excel training session with us.
In response to your question, you can create macros to make a lot of the mundane Excel tasks run very quickly, depending on what you are looking to do.
When you want to record a macro, I first suggest running through the steps on a dry-run, to make sure you know exactly what you need to record in your macro. Then when you're ready, go to Tools > Macro > Record new macro. You will be asked to name the macro, and give it a keyboard shortcut if you would like. Then once you click OK, you will be in recording mode. Everything you do from here will be recorded as part of the macro, until you click the stop recording button. If you have specific requirements for your reports that I can help with, I'd be glad to go over those with you.
I hope this resolves your question. If it has, please mark this question as resolved. If you require further assistance, please reply to this post. And please feel free to ask any other questions you may have.
Have a great day.
Regards,
Mara
Microsoft Office Specialist Master Trainer
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Moving between split pane sections in a spreadsheetIf you have used the split panes feature in your worksheet, use the following keyboard shortcut keys to move quickly and effortlessly between paned sections: |