Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros

Macros

ResolvedVersion 2003

Wed 23 Apr 2008, 15:51 Delegate Claire said...

Claire has attended:
Excel Advanced course

Macros

Can macros record sums and Vlookups for different spreadsheets and are they easier to use rather than copy and paste formats?

Thu 8 May 2008, 17:41 Edited on Thu 8 May 2008, 17:41 Trainer Tracy said...

RE: Macros

Hi Claire,

You can use a macro to add up certain figures relative to where your active cell is. I wouldn't say it was easier.... its a difficult question to answer without knowing how frequently you need to do it and the context.

A macro is simply a repetitive action. So in theory you can set a macro to add up two figures (or more). I couldn't say whether it would be quicker just to use the sum function... Good question

Tracy

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Using the Quick Access Toolbar in Excel2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Excel hints and tips

Macros

Macros

RE: Macros

Excel articles

Excel tip:

Using the Quick Access Toolbar in Excel2010