98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Macros
Macros
Resolved · 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?
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 information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Shortcut fill a cell with contents from adjacent cellsUse 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! |