+ Reply to Thread
Results 1 to 5 of 5

INDIRECT Function Drop Down Menu

  1. 06-17-2014, 10:52 AM #1
    Zita
    Zita is offline
    Registered User
    Join Date
    06-13-2014
    Posts
    10

    INDIRECT Function Drop Down Menu

    Hello everyone,

    I am having trouble with this excel document and I hope you can help me out.

    The goal is to make a monthly report for my job out of several excel sheets. I want the data to automatically fill in, without having to type it all.

    I followed all of the instruction in this INDIRECT function video, but that just did not work: https://www.youtube.com/watch?v=cjBEBn6YMi0

    When I select a month in the dropdown menu, I want the numbers to be linked to that month and therefor automatically change.

    I added an excel sample.

    Thank you!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-17-2014, 11:30 AM #2
    Hawkeye16
    Hawkeye16 is offline
    Valued Forum Contributor Hawkeye16's Avatar
    Join Date
    02-27-2013
    Location
    Holland
    MS-Off Ver
    ├•┤ Pew Pew
    Posts
    441

    Re: INDIRECT Function Drop Down Menu

    Do you need all the formulas to be the same or are you OK with each Country/tab having it's own formula?
    Despite the high cost of living, it remains very popular.

    Don't forget to mark threads SOLVED when you get an answer and rep all the geniouses that helped you today!
    Reply With QuoteRegister To Reply
  3. 06-19-2014, 05:57 AM #3
    Zita
    Zita is offline
    Registered User
    Join Date
    06-13-2014
    Posts
    10

    Re: INDIRECT Function Drop Down Menu

    I am okay with each country/tab having its own formula.
    Reply With QuoteRegister To Reply
  4. 06-19-2014, 06:26 AM #4
    Mysore
    Mysore is offline
    Forum Contributor
    Join Date
    01-03-2012
    Location
    Sydney
    MS-Off Ver
    Excel 2016,Excel 2013
    Posts
    186

    Re: INDIRECT Function Drop Down Menu

    Hi Zita

    Does this help? Just used Index and match to pull data from other sheets.

    Cheers
    Attached Files Attached Files
    Don't forget to rate 1 who helped u, using "Star"
    Reply With QuoteRegister To Reply
  5. 06-19-2014, 06:39 AM #5
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: INDIRECT Function Drop Down Menu

    See the attached file
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] vlookup, drop down, indirect function
    By shingudaze in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-17-2014, 03:02 AM
  2. [SOLVED] Can't Get Indirect Function to Work in Menu
    By BigBadBill in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-27-2013, 01:49 PM
  3. Indirect Function - drop down starts at end of list
    By specialfx in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 04-17-2013, 11:16 AM
  4. Error with Dependant Drop downlist (using INDIRECT function)
    By johnkelly11 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-28-2013, 07:10 AM
  5. [SOLVED] Drop down menu-How do you produce a drop down menu in a single cell in Excel
    By Freddo in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-04-2006, 04:35 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1