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

macros

ResolvedVersion 2007

Fiona has attended:
Excel Introduction course

Macros

I am really interested in learning how to create macros as I am often required to compile spreadsheets which pull information from several different workbooks in one place.

RE: Macros

Hi Fiona,

Thank you for your question and welcome to the forum.

Macros are used to automate a process you repeat multiple times.
Please find the links below to help you understand the process.

http://www.jitbit.com/macro-recorder/

http://office.microsoft.com/en-gb/word-help/record-or-run-a-macro-HA010099769.aspx

I hope this helps you.

Regards

Simon

Fri 23 Nov 2012: Automatically marked as resolved.

Excel tip:

Display developer tab - Excel 2010

a. In Excel, click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the box next to Developer in the list of tabs on the right hand side of the dialog box. When ticked the Developer tab will be visible.
e. Click OK to apply your changes

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.17 secs.