+ Reply to Thread
Results 1 to 5 of 5

Show Tables or data from SHEET 2 to SHEET 1

  1. #1
    Registered User
    Join Date
    04-13-2020
    Location
    Philippines
    MS-Off Ver
    2013
    Posts
    22

    Show Tables or data from SHEET 2 to SHEET 1

    Good day! Is it possible in excel to show the table in sheet 2 to sheet 1 based on the drop down value? If I will change the drop down value, then the table will change. Should I use VLOOKUP for that or there's something else that I should use?
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,083

    Re: Show Tables or data from SHEET 2 to SHEET 1

    Let each table be a named range:

    grade_1 =Sheet2!$H$3:$I$6
    JUNIOR_KINDER =Sheet2!$B$3:$C$5
    SENIOR_KINDER =Sheet2!$E$3:$F$5

    In B4, refer to the named ranges by replacing the spaces in the dropdown list with "_":
    Please Login or Register  to view this content.
    In B5:
    Please Login or Register  to view this content.
    copied across and down.
    Attached Files Attached Files
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    04-13-2020
    Location
    Philippines
    MS-Off Ver
    2013
    Posts
    22

    Re: Show Tables or data from SHEET 2 to SHEET 1

    It worked! Thank you!

  4. #4
    Registered User
    Join Date
    04-13-2020
    Location
    Philippines
    MS-Off Ver
    2013
    Posts
    22

    Re: Show Tables or data from SHEET 2 to SHEET 1

    Quote Originally Posted by protonLeah View Post
    Let each table be a named range:

    grade_1 =Sheet2!$H$3:$I$6
    JUNIOR_KINDER =Sheet2!$B$3:$C$5
    SENIOR_KINDER =Sheet2!$E$3:$F$5

    In B4, refer to the named ranges by replacing the spaces in the dropdown list with "_":
    Please Login or Register  to view this content.
    In B5:
    Please Login or Register  to view this content.
    copied across and down.
    Thanks for the worksheet! Your worksheet worked fine but when I do it in my main worksheet, it didn't worked. I'm still having a problem with the showing of table data. I follow your instructions but still it didn't worked. What do you think is the problem?

  5. #5
    Registered User
    Join Date
    04-13-2020
    Location
    Philippines
    MS-Off Ver
    2013
    Posts
    22

    Re: Show Tables or data from SHEET 2 to SHEET 1

    I already figured it out! My mistake is that I refer the cell into a wrong one. Anyway, 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. If/OR formula, criteria met on Sheet A, show data from Sheet B onto Sheet A
    By GerrardYNWA in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-07-2020, 07:57 PM
  2. Need to calculate 4 tables in a sheet and show fix result in fix cells
    By udprocks in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-01-2020, 03:17 AM
  3. Select a Sheet in Combobox. Show that's Sheet Data in Listbox.
    By svgopalareddy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-03-2018, 09:53 AM
  4. Replies: 6
    Last Post: 04-22-2014, 11:32 AM
  5. [SOLVED] show a list of names on from sheet 1 in sheet 2 when marked active in sheet 1...???
    By stolen_83 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-11-2013, 04:57 PM
  6. Replies: 0
    Last Post: 12-20-2012, 10:51 PM
  7. Replies: 3
    Last Post: 05-17-2012, 08:53 PM

Tags for this Thread

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