+ Reply to Thread
Results 1 to 7 of 7

Indexing entire tables from multiple sheets in one excel sheet

  1. #1
    Registered User
    Join Date
    06-08-2020
    Location
    Kampala
    MS-Off Ver
    2019
    Posts
    6

    Indexing entire tables from multiple sheets in one excel sheet

    Hello everyone, i am caught up in this situation where it just seems unprofessional to keep changing sheets to display the information they contain.
    If anyone can help me, i need to reference the tables from the 3 months (October, November and December) (each sheet represents its own month, never mind the figures i just cooked them up).
    I know how to create the drop down menu already on "Sheet4", and i needed each drop down selection to return a different table of the months they represent.
    Thankyou
    I tried attaching the excel file as an attachment but all that was in vain(both on firefox and edge)
    I have attached the excel file too.

    The file is publicly accessible here drive.google.com/file/d/1BCb7PQQvNdvHjkLYfaTZGjTab-ru2AE4/view?usp=sharing
    Attached Files Attached Files
    Last edited by anxious; 06-11-2020 at 06:42 PM.

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Indexing entire tables from multiple sheets in one excel sheet

    See the yellow banner on how to attach a file

  3. #3
    Registered User
    Join Date
    06-08-2020
    Location
    Kampala
    MS-Off Ver
    2019
    Posts
    6

    Re: Indexing entire tables from multiple sheets in one excel sheet

    The excel file
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    06-08-2020
    Location
    Kampala
    MS-Off Ver
    2019
    Posts
    6

    Re: Indexing entire tables from multiple sheets in one excel sheet

    OK thanks, i have finally uploaded it. The interface is a little complicated to use but am trying my best. Thank you again

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,557

    Re: Indexing entire tables from multiple sheets in one excel sheet

    Perhaps the following will help.
    Each monthly range is converted to a table and named, i.e. tblOctober.
    Each monthly table has the column heading Particulars placed in cell B4.
    Sheet 4 has the three column headings in row 4 then B5:D36 are populated using: =IFERROR(INDIRECT("tbl"&$C$2),"")
    Zero values hare hidden using custom formatting i.e. 0;-0;;
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  6. #6
    Registered User
    Join Date
    06-08-2020
    Location
    Kampala
    MS-Off Ver
    2019
    Posts
    6

    Re: Indexing entire tables from multiple sheets in one excel sheet

    Thank you so much JeteMc
    That is exactly what i wanted to have.
    JUST One more kind request, if you can recommend a tutorial on how to do that, it would be of great help, i need to simplify my results presentation in excel using tables like that.
    Thank You again

  7. #7
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,557

    Re: Indexing entire tables from multiple sheets in one excel sheet

    I don't know of any tutorials that detail the steps listed post #5.
    If you could show us an example of the simplified results that you would like displayed, then perhaps we could offer better help.
    Let us know if you have any questions.

+ 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] Search multiple sheets, return entire rows under each sheet name
    By Black Duck in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 01-21-2020, 02:11 AM
  2. Merging Multiple Sheets/ Tables to 1 Sheet
    By fotodude in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-08-2018, 02:42 PM
  3. Help indexing multiple sheets and matching multiple sheets
    By skell1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-11-2015, 11:16 PM
  4. [SOLVED] Indexing formula with multiple sheets
    By MikeSta4ord in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-22-2015, 11:59 AM
  5. Replies: 10
    Last Post: 02-20-2014, 04:09 PM
  6. [SOLVED] I need to search for a word on multiple sheets and copy the entire row to a new sheet
    By jkm750 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-26-2013, 12:13 AM
  7. Indexing Multiple Tables
    By Haywire79 in forum Excel General
    Replies: 6
    Last Post: 08-13-2010, 02:12 AM

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