+ Reply to Thread
Results 1 to 4 of 4

Help with INDIRECT function w/ multiple sheets

  1. #1
    Registered User
    Join Date
    05-13-2014
    MS-Off Ver
    Excel 2010
    Posts
    33

    Help with INDIRECT function w/ multiple sheets

    Hi there,

    I have 3-4 sheets of data within 1 workbook (each sheet represents 1 week).

    What im trying to do, is have a header page which allows a user to select a specific week, and have data populate in from that specific tab.

    How would I go about doing this?

    Thanks

  2. #2
    Valued Forum Contributor Miroslav R.'s Avatar
    Join Date
    05-16-2013
    Location
    NMnV, Slovakia
    MS-Off Ver
    Excel 2007
    Posts
    479

    Re: Help with INDIRECT function w/ multiple sheets

    Hi there,

    look at my attached example:
    Book1.xlsx

    Basically it is one formula linked to drop down (A2):

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Hope it helps
    Regards
    Miroslav R.

    (If You like my solutions, feel free to add reputation.)

  3. #3
    Registered User
    Join Date
    05-13-2014
    MS-Off Ver
    Excel 2010
    Posts
    33

    Re: Help with INDIRECT function w/ multiple sheets

    This works incredibly!

    Thanks for all of your help!

  4. #4
    Valued Forum Contributor Miroslav R.'s Avatar
    Join Date
    05-16-2013
    Location
    NMnV, Slovakia
    MS-Off Ver
    Excel 2007
    Posts
    479

    Re: Help with INDIRECT function w/ multiple sheets

    You are welcome!
    So if you want,add reputation by clicking on the star in bottom left corner of my posts.
    Do not forget to 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. Using Indirect function to sum across multiple sheets
    By Irishman07 in forum Excel General
    Replies: 10
    Last Post: 02-14-2018, 05:26 PM
  2. Using indirect within a countif on multiple sheets
    By slash_gnr3k in forum Excel General
    Replies: 2
    Last Post: 05-03-2012, 04:09 AM
  3. Using INDIRECT to access multiple sheets
    By nainishb in forum Excel General
    Replies: 3
    Last Post: 02-09-2010, 08:50 AM
  4. Indirect() between multiple sheets?
    By ctasich in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-30-2007, 10:12 AM
  5. [SOLVED] Sum Indirect function through multiple sheets
    By Andre Croteau in forum Excel General
    Replies: 2
    Last Post: 05-06-2005, 06:06 AM

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