creating macros and lookuptables
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Creating Macros and lookuptables

resolvedResolved · High Priority · Version 2003

replyReply Fri 7 Nov 2008, 16:38Delegate Ngozi said...

Creating Macros and lookuptables

How can I make use of both macrosand lookup tables for the same piece of work?

For upcoming training course dates see: Pricing & availability

replyReply Thu 20 Nov 2008, 10:23Trainer Amanda said...

RE: Creating Macros and lookuptables

Hi Ngozi

Thank you for your question and welcome to the forum.

This is a difficult question to answer, as it would depend if there is something specific that you wanted to achieve using lookups, where you think creating a macro might be of assistance.

If there is a specific example/scenario that you could describe where you are unsure if using lookups and macros in conjunction with each other would work, then by all means please let me know and I'll see if I can help.

Kind regards
Amanda

replyReply Thu 20 Nov 2008, 10:57Delegate Ngozi said...

RE: Creating Macros and lookuptables

Hi Amanda

Thanks for your repsonse. This has to do with something I am doing at work and I'm just looking at easier ways of doing things. I'll try and see if there is something specific that I can actually send to you to have a look at which should better explain what I am trying to do.

Kind regards


Ngozi

 

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

Excel tip:

Removing custom dictionary entries

If you add something to the custom dictionary in Excel you cannot remove it. The way to get around this is to go into word and remove it there.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard