+ Reply to Thread
Results 1 to 6 of 6

Feedback for fetching data with the indirect function

  1. #1
    Registered User
    Join Date
    03-16-2019
    Location
    Sweden
    MS-Off Ver
    2007
    Posts
    3

    Feedback for fetching data with the indirect function

    I try to create a dynamic sheet controlled by a dropdown menu. I have managed to create what I am looking for, but I think my solution is bad. I would therefore like some feedback or an alternative solution (i rather not use VBA, because I have no experience with it.

    This is how I built it:

    1) I use a activeX combobox to create my dropdown, it fetch its data from a table.
    2) After that i do a vlookup to get a "id" for that specific dropdown-choice.
    3) I then use the INDIRECT function to search for a tab/sheet with a corresponding name and then print the information from A1.
    4) I then repeat step 3 for A2,A3 etc.


    /Pew

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Feedback for fetching data with the indirect function

    Hi Pew,

    It might help if you attach a sample file to illustrate your setup, what you've tried, and what doesn't work.

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    03-16-2019
    Location
    Sweden
    MS-Off Ver
    2007
    Posts
    3

    Re: Feedback for fetching data with the indirect function

    Thanks for the input, i have added a example file.
    Attached Files Attached Files

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Feedback for fetching data with the indirect function

    Looking at your sheet I see nothing wrong with your formulas.

    The only suggestion, using a ActiveX combobox seems overkill. What not just use a data validation dropdown in C6.

  5. #5
    Registered User
    Join Date
    03-16-2019
    Location
    Sweden
    MS-Off Ver
    2007
    Posts
    3

    Re: Feedback for fetching data with the indirect function

    Thanks for having a look!
    I had wished there was some way to retrieve multiple cells with one request. That B11, for example, fetched the cells A1: A20
    Or that i could be able to mirror a text box.

    The ActiveX combobox i picked for the ability to change the look/size of the dropdown and also so that i can "search" in the list.
    Maybe it is possible with "data validation" also?
    Last edited by AliGW; 03-17-2019 at 03:48 AM.

  6. #6
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Feedback for fetching data with the indirect function

    I had wished there was some way to retrieve multiple cells with one request. That B11, for example, fetched the cells A1:A20 Or that i could be able to mirror a text box.
    I don't quite understand what you are wanting in this retrieve multiple cells. Fetch A1:A20? On the dropdowndata tab?

    The ActiveX combobox i picked for the ability to change the look/size of the dropdown and also so that i can "search" in the list. Maybe it is possible with "data validation" also?
    It's not possible with data validation to filter as you type. This would require VBA.

+ 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. Help for Fetching the Data....
    By smj.mano22 in forum Excel General
    Replies: 2
    Last Post: 03-01-2019, 08:06 AM
  2. Replies: 2
    Last Post: 01-12-2017, 09:51 PM
  3. [SOLVED] INDIRECT Function with multiple sheets - SUMIF, INDIRECT & MATCH
    By DJDRU in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-07-2014, 08:42 AM
  4. Getting data using Indirect function
    By mdharoonkhan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-18-2014, 10:35 PM
  5. Replies: 0
    Last Post: 10-03-2013, 02:02 AM
  6. Sumif function using indirect function and data from different sheet
    By pronky007 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2013, 12:40 PM
  7. Data fetching
    By shivarajm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-23-2012, 12:32 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