Solutions Through Learning
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training course london - Macros
Craig has attended:
Excel Advanced course
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?
you must record yourself doing selecting these columns first and the macro will follow suit
Before you type the equal sign, type an apostrophe: '
Then type your equal sign: = (and anything else you want to add after your equal sign)
Press ENTER.
(the apostraphe will disappear
TrustScore
4.9
/ 5
2394 reviews
Connect with us:
Call for assistance
We will call you back
Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.
