Results 1 to 2 of 2

Macro novice look for support - tricky:-)

Threaded View

  1. #1
    Registered User
    Join Date
    08-23-2012
    Location
    germany
    MS-Off Ver
    Excel 2007
    Posts
    1

    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.

Thread Information

Users Browsing this Thread

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

Bookmarks

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