+ Reply to Thread
Results 1 to 2 of 2

Populating row in a separate table based on value of cell

  1. #1
    Registered User
    Join Date
    11-06-2019
    Location
    Tasmania, Australia
    MS-Off Ver
    2016 Pro Plus
    Posts
    1

    Populating row in a separate table based on value of cell

    Hi guys,
    My first post here so I shall try my best to adhere to the rules and explain my problem as best i can.

    I am putting together a report that automatically populates a dashboard depending on data entered. In this instance, I have a list of people, their personal details and a column for the date they exited the temporary accommodation. I am wanting to populate some cells on the dashboard for people that have exited in the last month.

    Data
    Name DOB House Exit Date
    Bob Brown ##/##/## XYZ -
    Ryan Red ##/##/## XYZ -
    Gary Green ##/##/## XYZ 1/11/19
    Brad Blue ##/##/## XYZ -
    Peter Purple ##/##/## XYZ 3/11/19

    If i enter an exit date into the data table i would like it to return the Name and Exit Date but, only if there is data in the Exit Date column. Thus far i have been able to populate the dashboard if all people have an exit date but am left with some blank rows if there is only one or two who have departed.

    I hope this makes sense and apologies if i have failed to include anything.

    Any help would be much appreciated.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Populating row in a separate table based on value of cell

    Hi Matt,

    This looks like an Advanced Filter kind of question to me. If you know about Advanced Filters and have tried that, let us know. If not then look on the Data Tab and search the new a bit for some examples or YouTube videos.

    I'd like an attached file and what you expect as a result and I'd do it for you. Hope this helps.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ 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. [SOLVED] Populating a master database based on separate worksheets
    By bkdre in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-17-2018, 06:33 PM
  2. Auto-populating a separate sheet based on a dropdown menu
    By Graceful97 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-04-2016, 01:52 AM
  3. [SOLVED] populating a table from a separate sheet based on ranking
    By greggatz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-21-2014, 02:54 PM
  4. Populating a Table based on info appering in another cell
    By Paul GF in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 10-18-2013, 07:17 AM
  5. Populating a Table based on info appering in another cell
    By Paul GF in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-18-2013, 06:46 AM
  6. Replies: 4
    Last Post: 03-26-2013, 07:36 AM
  7. Populating various cells in a range based on a table of cell addresses
    By cm115 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-28-2013, 02:55 PM

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