+ Reply to Thread
Results 1 to 5 of 5

Pull Data from Multiple Columns Based On Data Validation List Selection

  1. #1
    Registered User
    Join Date
    11-03-2004
    Posts
    75

    Exclamation Pull Data from Multiple Columns Based On Data Validation List Selection

    Data validation works fine. Trying to pull data from another tab based upon a selection made within the drop down data validation list. Small test file provided to show challenge.

    In advance, THANKS for the guidance!

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,867

    Re: Pull Data from Multiple Columns Based On Data Validation List Selection

    Please see the attached file.

    Kindly let me know if this is not what you wanted!!

    Thank You,

    Deep
    Cheers!
    Deep Dave

  3. #3
    Registered User
    Join Date
    11-03-2004
    Posts
    75

    Re: Pull Data from Multiple Columns Based On Data Validation List Selection

    Fabulous! Works beautifully - Thank you! I used to be really good at pulling data like this but its been a long time and my macro vba writing is rusty. I'll study the example as a refresher and appreciate the guidance!

  4. #4
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,867

    Re: Pull Data from Multiple Columns Based On Data Validation List Selection

    Glad it helps!!



    Thank You,

    Deep

  5. #5
    Registered User
    Join Date
    11-03-2004
    Posts
    75

    Exclamation Re: Pull Data from Multiple Columns Based On Data Validation List Selection

    ATTACHED is an updated version of the file to accommodate 3 rows of data!
    Is there a way to replicate the code more efficiently to cover a large number of rows within the column C.
    The code you provided works wonderfully and I LOVE IT, but it only works for a single row.
    I've taken that code and pasted it a few more times downward and adjusted it to paste in several rows.

    The problem is, I anticipate this tracking sheet to track 100-300 rows at a time.
    This would require me to paste that code up to 300 times and adjust each chunk to accommodate each row.
    I can certainly spend the time to paste it 300 times and update the references, but I'm worried that when the UPDATE button it hit, it might lock up because its going to have to go through a LOT of code to load those 300 rows.

    If you think it will be the best route, let me know and I'll proceed with copying it 300 times downward within the code. THANKS!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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