macros

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

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

Macros

resolvedResolved · Low Priority · Version 2003

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?

Edited on Thu 8 May 2008, 17:41

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


 

Excel tip:

Shortcut fill a cell with contents from adjacent cells

Use Control + D to fill a cell with the data from an adjacent cell. This speeds up data entry and is a cool tip to share!


View all Excel hints and tips


Server loaded in 0.08 secs.