Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

macros

ResolvedVersion 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

Excel tip:

Autonumber in Excel

To create an autonumber field, can use the Offset() function.

In cell A1, enter the number 1.
Then in cell A2, enter this formula:

=OFFSET(A2,-1,0)+1

Then copy the formula from cell A2, down as far as you need.

See also: Autonumber in Excel forum post.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.