+ Reply to Thread
Results 1 to 5 of 5

Assistance with linking certain data from one Excel tab to another

  1. #1
    Registered User
    Join Date
    02-09-2018
    Location
    Rancho Cucamonga
    MS-Off Ver
    2013
    Posts
    3

    Assistance with linking certain data from one Excel tab to another

    Hello,

    I am seeking assistance on how to link certain data from a master tab to various sub tabs.

    The master tab is below. It has several columns, including ID Number, DATE, NAME, AGE, LOCATION, and FRUIT.

    \1

    On a separate tab, I would like to enter the ID Number in the red cell, and have the data in the corresponding rows from the master tab with the same ID number automatically populate (but only DATE, NAME, AGE, and LOCATION, not FRUIT.

    \1

    For example, if I entered in "17" in the red cell in the separate tab, the data in the DATE, NAME, AGE, and LOCATION columns from the master tab only with "17" in the ID number column would then automatically populate on the separate tab.

    Is this possible?

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Assistance with linking certain data from one Excel tab to another

    Post a spreadsheet not an image.
    We cant test data in an image.

    Post a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.
    Use the Go Advanced option at the bottom of the page then scroll down to Manage Attachments as the "paperclip" method does not work on this forum.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    02-09-2018
    Location
    Rancho Cucamonga
    MS-Off Ver
    2013
    Posts
    3

    Re: Assistance with linking certain data from one Excel tab to another

    See attached.

    There are 3 tabs: The Master Tab from which information is pulled, a blank version the "Separate Tab," and the expected results version of the "Separate Tab."

    Thank you.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Assistance with linking certain data from one Excel tab to another

    in A4
    =IFERROR(INDEX('Master Tab'!$A$2:$E$1000,SMALL(IF(('Master Tab'!$A$2:$A$1000=$B$1),ROW($A$2:$A$1000)),ROW(A1))-(ROW(A$2)-1),COLUMN()+1),"")
    Array formula, use Ctrl-Shift-Enter
    copy across and down the columns

  5. #5
    Registered User
    Join Date
    02-09-2018
    Location
    Rancho Cucamonga
    MS-Off Ver
    2013
    Posts
    3

    Re: Assistance with linking certain data from one Excel tab to another

    Truly amazing, thank you!

+ 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] Assistance in Linking Cells into Several Worksheet
    By shuriyan0924 in forum Excel General
    Replies: 5
    Last Post: 02-11-2015, 10:01 AM
  2. In over my head, need some assistance with Excel for locating duplicate data
    By Heath82 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-22-2014, 10:36 AM
  3. Linking/unlinking chart Assistance Please
    By jam320 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-25-2014, 05:59 PM
  4. Replies: 5
    Last Post: 01-07-2013, 02:49 AM
  5. Assistance with Excel Data
    By CFR01 in forum Excel General
    Replies: 4
    Last Post: 03-31-2011, 01:57 PM
  6. Need assistance linking workbooks by date
    By bsmith in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-19-2005, 04:30 PM
  7. [SOLVED] Assistance with linking please...
    By Tom Bradstreet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-07-2005, 05:06 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