+ Reply to Thread
Results 1 to 6 of 6

Pulling Data from Different sheet using Drop-down list.

  1. #1
    Registered User
    Join Date
    12-07-2019
    Location
    Appleton Cheshire
    MS-Off Ver
    Office 365
    Posts
    19

    Pulling Data from Different sheet using Drop-down list.

    Im trying to create a quote builder using formulas or VBA, my workbook has 3 sheets:

    Sheet 1 - Label Quote Builder
    Sheet 2- Quote
    Sheet 3 - Data

    When Cell I6 in Label Quote builder is selected, is there a way that Sheet2 - Quote, will look at quantity and prices from the table in sheet 3 relating to Cell I6 in sheet 1?

    I've tried different formulas with v lookup,match,index etc,. I can't find anything that will do what I want. (i might not be programming it right!)
    I was thinking that maybe VBA is the way forward, but i'm new to creating VBA's.

    I have uploaded my spreadsheet.
    Attached Files Attached Files

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Pulling Data from Different sheet using Drop-down list.

    Your project is password protected. How is the quantity determined? What should the output look like?

    Thinking of an event in the builder to trigger the macro, we have this so far:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    12-07-2019
    Location
    Appleton Cheshire
    MS-Off Ver
    Office 365
    Posts
    19

    Re: Pulling Data from Different sheet using Drop-down list.

    Thank you for you're Quick response.

    I've taken the password off.

    All i need is the price depending on the Qty to appear in column F on the Quote depending on the scheme tables in Data
    Attached Files Attached Files

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Pulling Data from Different sheet using Drop-down list.

    It's not very pretty but seems to work in your Sheet3(Quote) module:

    Please Login or Register  to view this content.
    Last edited by xladept; 05-09-2020 at 01:18 PM. Reason: Define triggering area

  5. #5
    Registered User
    Join Date
    12-07-2019
    Location
    Appleton Cheshire
    MS-Off Ver
    Office 365
    Posts
    19

    Re: Pulling Data from Different sheet using Drop-down list.

    Thank you for this!

    When I use it on my Personal laptop with Office 365, it works but when i've tried the code on my other laptop with office 2010, i'm getting a compile error " can not find project library"?

    Once again thanks for your help

    Karl

  6. #6
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Pulling Data from Different sheet using Drop-down list.

    Hi Karl,

    I wrote it in 2010 so maybe you need to reference another library - tools/reference and see what sticks out

+ 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. Pulling Data From Individual Tabs Based On Drop Down On A Separate Sheet
    By RandyD123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-07-2015, 10:43 AM
  2. [SOLVED] Lookup returning #NA when pulling from data validation drop down list?
    By cytokin33 in forum Excel General
    Replies: 9
    Last Post: 01-07-2015, 01:48 PM
  3. Replies: 2
    Last Post: 03-03-2014, 03:31 PM
  4. [SOLVED] Formula not pulling the correct data based on a drop down list
    By pleasesmile in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-27-2013, 10:46 AM
  5. in pulling data in a form with a drop down list
    By roseieroses in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-03-2013, 09:16 PM
  6. pulling a list from another sheet as a drop down?
    By mryder30 in forum Excel General
    Replies: 4
    Last Post: 07-14-2012, 02:16 AM
  7. Pulling Data From Another Sheet with Drop Down Menu
    By chbrandt in forum Excel General
    Replies: 6
    Last Post: 04-07-2010, 02:02 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