+ Reply to Thread
Results 1 to 4 of 4

Getting latest information from one sheet to another.

  1. #1
    Registered User
    Join Date
    04-19-2021
    Location
    New York
    MS-Off Ver
    Office 2016
    Posts
    2

    Getting latest information from one sheet to another.

    I am working creating a mental health care coordination spreadsheet along with a dashboard for my clinic.

    Here a brief framework of what I am working with.
    - Dashboard: Where the staff can see a summary of the patient mental health screeners and appointment information. This is the only sheet that will not be completely locked and will be accessible to everyone.
    - Roster: List of all the patients with one unique identifier and some other important info.
    - Interactions: Sheet with multiple entries for each patient that will include key data points from each patient interaction.
    - Screener Database: This sheet includes all of the patient mental health screener scores that are being displayed on the dashboard through pivot tables.

    My current issue:
    I would like to pull the latest 'current level', 'Interaction note' and 'interaction type' from the 'interaction' sheet using a formula to show on the 'BHI Roster' Sheet

    Also, if you have suggestions to improve the worksheet, they are very much welcome!

    Thanks for your help!
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: Getting latest information from one sheet to another.

    The entries in Interaction are in ascending date order (for each person, if not for the entire list...), so you can use this:

    =LOOKUP(2,1/(Table_Interactions[[MRN]:[MRN]]=Table_BHIRoster[@[MRN]:[MRN]]),Table_Interactions[Current Level])

    copied across and down.
    Attached Files Attached Files
    Glenn



  3. #3
    Registered User
    Join Date
    04-19-2021
    Location
    New York
    MS-Off Ver
    Office 2016
    Posts
    2

    Re: Getting latest information from one sheet to another.

    This works perfectly!
    Thank you!

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: Getting latest information from one sheet to another.

    You're welcome.



    It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

    Finally, if that takes care of your original question, please select "Thread Tools" from the menu link above and mark this 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)

Similar Threads

  1. clear out 3 calendar tabs and update latest content based on information
    By abressler in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-30-2019, 02:13 PM
  2. [SOLVED] Drawing the latest information from a range of numbers
    By davemek21 in forum Excel General
    Replies: 5
    Last Post: 09-23-2016, 04:59 AM
  3. [SOLVED] Enter information on one sheet based on the information in another sheet in the same wkbk
    By slindfors in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-19-2015, 03:16 PM
  4. INDEX MATCH to seek the latest information
    By sampahmel in forum Excel General
    Replies: 4
    Last Post: 05-05-2015, 10:29 AM
  5. [SOLVED] Return latest date Part repair information from an array
    By Martin Chamberlin in forum Excel General
    Replies: 2
    Last Post: 05-15-2014, 10:13 PM
  6. Replies: 9
    Last Post: 11-28-2013, 05:20 PM
  7. Macro to Pull information from one Excel Sheet based on information in another sheet
    By IwannabanExcelGod in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-20-2013, 02:11 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