How do you set up macros for data reports I put together frequently?

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