Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Macros

Resolved · Low Priority · Version 2003

Reply Wed 23 Apr 2008, 15:51Delegate 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?

For upcoming training course dates see: Pricing & availability

Reply Thu 8 May 2008, 17:41 Edited on Thu 8 May 2008, 17:41Trainer 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

Excel articles

· VBA Excel 2007
· How Excel Can Transform All Of Your Office Documents
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Find Out How To Create That Missing Link With Excel
· Replacing Cell Formats In An Entire Excel Workbook

Please browse our web site to find out more about
excel training course and other Microsoft training courses.

Excel tip:

Shortcuts for working with named ranges in Excel

If you are working with or creating named ranges in your spreadsheets, then you may find the following shortcut keys useful.

- Bring up the Define Names dialogue box on screen by using Ctrl + F3 (instead of going to Insert - Names).

- Create Names from labels you have entered into the spreadsheet by highlighting the labels and related figures, then hold down Shift + Ctrl + F3. You can then choose to create names from the top or bottom rows, or left or right columns.

- Go directly to a named range by hitting the F5 key. The Go To dialogue box will open and display any named ranges in the spreadsheet. Simply select the named range to navigate to it in the spreadsheet.

View all Excel hints and tips