excel training course london - Macros

The UK's most regular instructor-led training courses.
Training information: excel training course london · Excel training course · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Macros

Craig has attended:
Excel Advanced course

by - delegate Craig [2 posts] (2007 Mar 21 Wed, 09:46) Reply

How do I use macros to populate different columns depending upon a criteria. For example 1 would allocate that figure to column C, 2 to column D etc?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	1	book now	£495	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	3	book now	£475	£495
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	4	book now	£475	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	3	book now	£475	£495
2003	2008 Oct 23 Thu + 24 Fri	Southwark	4	book now	£475	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Macros

by - trainer Garry gold contributer [188 posts] (2007 Mar 29 Thu, 12:31) Reply

you must record yourself doing selecting these columns first and the macro will follow suit

· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Prepare for your MOS Certification with MS Excel Courses
· How to Create Better Excel Spreadsheets: Part Two
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Features of Microsoft Excel that assist in Analysis of Financial Data

Excel tip:

Edit and format multiple worksheets in one operation

To select two or more non-adjacent worksheets, click on the tab of each worksheet, while holding down the [CTRL] key.
To select two or more adjacent worksheets, click on the tab of the first worksheet and then on the tab of the last worksheet, while holding down the [SHIFT] key.
Enter or modify your data and apply the necessary formatting options to the sheet that's displayed

View all Excel hints and tips