+ Reply to Thread
Results 1 to 1 of 1

Construct table dynamicly from masterdata based on a criteria

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

    Question Construct table dynamicly from masterdata based on a criteria


    I need some input on how to proceed with my excel sheet.
    Do give you a understanding of a the scenario. This is a projectplan where a consultant will be entering activities under the "masterdata" tab. He will then set a "category type" on that activity.

    My first tab is a table which I want activites (From MasterData tabs) to be listed, but grouped based on the sub titles (Planning, installation, design, configuration etc..)
    Screenshot 2020-01-12 at 00.42.04.png

    Under masterdata I have a created a table called (tblAktiviteter) which is the list in column A and B. Column A matches by name with the sub titles on the first tab and will be the key for grouping.
    Screenshot 2020-01-12 at 00.43.26.png

    I want this to be dynamic, so If I had more activities in the masterdata table and set a category, it will be listed in first tab.

    Thanks in advanced!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Construct a complex table
    By tcebob in forum Excel General
    Replies: 2
    Last Post: 05-12-2017, 10:04 AM
  2. [SOLVED] VBA code 3 way lookup replace the old value by new value from masterdata
    By MicroTees in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-20-2015, 06:01 AM
  3. index/match: construct 2 new 'tables' from 1 dynamic 'table'
    By rny1ef in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-21-2015, 07:30 AM
  4. [SOLVED] [HELP!] How to construct a DB like sheet from a table in Excel
    By wieckedkyle in forum Excel General
    Replies: 6
    Last Post: 10-28-2014, 04:39 AM
  5. Copy Column(s) based on another column dynamicly without blanks
    By johnmelvin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-23-2013, 12:24 PM
  6. Replies: 0
    Last Post: 12-19-2012, 01:23 PM
  7. Dynamicly update cells based on list?
    By garyi in forum Excel General
    Replies: 5
    Last Post: 01-26-2011, 08:03 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1