+ Reply to Thread
Results 1 to 2 of 2

Macro novice look for support - tricky:-)

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2007

    Macro novice look for support - tricky:-)

    Hi all, I am very novice to Macro programming (in fact I most of the time only record them an only make some changes in the macro itself :-)
    but now, macro recording is not sufficient anymore to solve the following problem:

    I have in the same workbook:
    Worksheet A with a list of trainings names in cells A2 to A45
    Worksheet B with a list of names in cells C2 to C250
    Worksheet C listing training completion (only listed if the training was done) with
    training names in column A, Completion date in column B, Names in column C
    Worksheet D, with a Matrix showing per Name/Training if YES/NO the training is required for this person

    I want to do the following:
    in worksheet B, for all names, starting Cell E2
    check in Worksheet D if the training is required for each person-
    if no - display " not required"
    if yes, check in Worksheet C if a training completion date is listed for this person
    if listed - display the completion date from Worksheet C
    if not listed - display "missing record"

    I have no idea if something like this is possible - and I would be very grateful for any kind of support!
    I attach an example of the workbook for better understanding.

    If it is not clear please post a reply with your questions!THANKS A LOT FOR YOUR HELP!
    Attached Files Attached Files
    Last edited by IDO78; 08-23-2012 at 02:03 PM.

  2. #2
    Forum Expert
    Join Date
    Leghorn, Italy
    MS-Off Ver
    Excel 2010

    Re: Macro novice look for support - tricky:-)

    Forum Rules

    Please read and adhere to these simple rules!

    1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    If solved remember to mark Thread as solved

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1