Results 1 to 7 of 7

Extract data from specific table using dropdown list to select table

Threaded View

Maggie.S Extract data from specific... 10-05-2018, 05:14 AM
Pete_UK Re: Extract data from... 10-05-2018, 06:09 AM
Pete_UK Re: Extract data from... 10-05-2018, 06:36 AM
Maggie.S Re: Extract data from... 10-08-2018, 07:25 AM
Pete_UK Re: Extract data from... 10-08-2018, 07:56 AM
Maggie.S Re: Extract data from... 10-08-2018, 09:07 AM
Pete_UK Re: Extract data from... 10-08-2018, 09:21 AM
  1. #1
    Registered User
    Join Date
    10-04-2018
    Location
    Staffordshire
    MS-Off Ver
    2016
    Posts
    3

    Extract data from specific table using dropdown list to select table

    Hi all

    I have very basic knowledge of excel, but am able to cobble formulas to get it to do what is required.

    I was tasked with putting together a costs calculator for my sales team, so they could give customers an on site budget estimate for roller blinds based on dimensions.

    What I have devised, is a list of materials available, and in that line they are able to select available dimensions (drop & width) which then displays the correct cost value from a table that particular material relates to.

    I have managed to get a match formula to work, and everyone is extremely impressed with how it works. Unfortunately, they are too impressed and now want me to adapt the cost sheet so instead of having separate lines for each material, they can select the material from a drop down menu, which will then fetch the values data from the correct table. This is so they can have multiple lines of the same material or mix and match quantities one a single cost sheet.

    I have looked and looked, but cannot figure out how to get the value from the initial drop down list to select the data from the correct table.

    Is this actually possible at all, and if so, could someone point me in the right direction regarding formulas etc.

    many thanks in advance.

    Maggie - getting older by the minute!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Extract data table from a specific web url
    By SBBmaster09 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-27-2017, 07:16 AM
  2. Extract data table from a specific web url
    By SBBmaster09 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-16-2017, 09:36 AM
  3. [SOLVED] Select and Extract a line of Data in a Table to Populate a Template Worksheet
    By DGAlamo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-20-2016, 11:30 AM
  4. How to extract data of any specific day out of pivot table.
    By mir.mudassir in forum Excel General
    Replies: 1
    Last Post: 02-02-2015, 09:44 PM
  5. Select item of a dropdown list (data validation) and refresh one pivot table
    By ATN123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-17-2014, 07:40 AM
  6. Replies: 9
    Last Post: 02-26-2014, 04:17 PM
  7. Extract specific data from a table
    By Kristof088 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-10-2012, 09:07 PM

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