Results 1 to 7 of 7

Thread: Lookup Tables

  1. #1

    Post Lookup Tables



    Register for a FREE account, and/
    or Log in to avoid these ads!

    We have put together a master employee DB sheet.Table called cours_index contain details on courses.A table with same name as course name will be created for each entry in Index[Course] to capture course details which will be displayed in a new tab with same name of course (Done through macro)

    formulea/macro should pick each employee from this DB and count the number of courses he/she attended and update it in employee DB itself.Also each course is attached with specific learning hours . Formulea/Macro should also find the total learning hours of a person and update it in employee DB.As mentioned earlier,Courses will get added dynamically .so Formulea/Macro should take this into consideration.I have attached a file for your review .

    Bare with me just 1 more time . Sorry that i informed abt change in requirements late
    Attached Files Attached Files

  2. #2
    Seeker DSDressler's Avatar
    Join Date
    Dec 2014
    Location
    Bend, OR
    Posts
    18
    Articles
    0

    Post

    This may help - nothing fancy...
    Attached Files Attached Files

  3. #3
    Seeker DSDressler's Avatar
    Join Date
    Dec 2014
    Location
    Bend, OR
    Posts
    18
    Articles
    0
    Just do the same for Learning Hours using a SUMIFS and appropriate sheet columns. Note the I altered the columns to standardize the data locations among the worksheets.

  4. #4
    Seeker DSDressler's Avatar
    Join Date
    Dec 2014
    Location
    Bend, OR
    Posts
    18
    Articles
    0
    Trial_v1-REV-2.xlsx
    Quote Originally Posted by DSDressler View Post
    Just do the same for Learning Hours using a SUMIFS and appropriate sheet columns. Note the I altered the columns to standardize the data locations among the worksheets.
    Attached if Rev-2.

  5. #5

    Post

    Quote Originally Posted by DSDressler View Post
    Trial_v1-REV-2.xlsx

    Attached if Rev-2.
    This may not work out .As i mentioned in the first post , Courses get added dynamically . so as and when a new course get entered in Index table , A new table with same name and format as other course tables, will be created and details pertaining to newly added course will be entered in newly created table .
    Formulea must cater to this dynamic addition of new tables.But the formulea you mentioned is catering to just 4 courses mentioned in support file.This was just an example i gave.

  6. #6
    Seeker DSDressler's Avatar
    Join Date
    Dec 2014
    Location
    Bend, OR
    Posts
    18
    Articles
    0
    I'd like to keep this alive... I'm able to do all be add the new worksheet given an Index w/s entry and think (many would figure this out already) that you need a function macro to complete that or all of the entries. I shall keep working on this.

  7. #7
    Thank you so much. Will keep you posted.

Tags for this Thread

Posting Permissions

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