Results 1 to 7 of 7

Indexing entire tables from multiple sheets in one excel sheet

Threaded View

  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.

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