Results 1 to 4 of 4

Populate other cells based on pick list selection and db results matching those criterea

Threaded View

  1. #1
    Registered User
    Join Date
    08-14-2024
    Location
    Cleveland, Ohio
    MS-Off Ver
    Office 365
    Posts
    19

    Question Populate other cells based on pick list selection and db results matching those criterea

    I've gotten great help here in the past, so I'm hoping someone can assist here also.

    I'm trying to use a pick list to select a machine type. Once selected other cells are filled with the corresponding data. Things like a header and several bullet points and a price. I have all this data in an excel sheet and I've imported it to a SQL database. I've tried several times and have been able to create the connection, but I can't seem to sort out how to query data to individual cells.

    Attachment 888304

    So from the screenshot, if I pick the machine manually in the "Part Number" column, I'd like the other fields to populate with the corresponding data. My aim was to use a SQL query, something like..

    insert [Header$] where [Part Number] = '[Part_Number]'

    I'm sure the query isn't quite right, but I haven't even been able to get to the point where I could troubleshoot that portion.

    Attached is a sample sheet. Happy to help clarify if this isn't helpful.

    Thanks!Screenshot 2025-02-05 162218.png
    Attached Files Attached Files
    Last edited by Newguy25; 02-05-2025 at 06:08 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Auto populate cells based on drop down list selection
    By NiesahClark in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-16-2021, 02:06 AM
  2. [SOLVED] Auto populate cells based on a drop down list selection
    By Ronald Reagan in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-10-2020, 05:14 PM
  3. Replies: 8
    Last Post: 05-24-2017, 06:35 AM
  4. [SOLVED] Auto-populate cells based on drop down list selection
    By sh1483 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-01-2016, 11:59 PM
  5. Multiple selection from pick list - only some cells work
    By markfranklin99 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-09-2012, 11:20 PM
  6. auto populate multiple cells based on a list selection
    By ikautzman in forum Excel General
    Replies: 3
    Last Post: 06-26-2009, 10:09 AM
  7. [SOLVED] Making pick list conditional on selection from previous pick list
    By Stewart in forum Excel General
    Replies: 1
    Last Post: 06-27-2005, 07:05 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