+ Reply to Thread
Results 1 to 10 of 10

Loop up and pull a list of data from 1 cell

  1. 01-07-2020, 01:11 PM #1
    bordemkills
    bordemkills is offline
    Registered User
    Join Date
    09-20-2016
    Location
    US
    MS-Off Ver
    2010
    Posts
    39

    Loop up and pull a list of data from 1 cell

    Good Morning,

    I'm trying to set up an excel sheet to where I input data into 1 cell in "Sheet 1" and it will pull multiple rows of data that contain the same info from "Sheet 2"

    Any help would be greatly appreciated, please see attached.

    Thanks,
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-07-2020, 01:32 PM #2
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,210

    Re: Loop up and pull a list of data from 1 cell

    Hi bordemkills

    This is one option...

    Put code in sheet1.Module...
    Please Login or Register  to view this content.
    Edit...The V2 Upload has incorporated error Trapping and Clear code....
    Attached Files Attached Files
    Last edited by sintek; 01-07-2020 at 01:46 PM.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  3. 01-07-2020, 01:38 PM #3
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Loop up and pull a list of data from 1 cell

    A filter in sheet2 is not possible ?
    Why not with a macro using B9 value.
    - Battle without fear gives no glory - Just try
    Reply With QuoteRegister To Reply
  4. 01-07-2020, 01:40 PM #4
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,210

    Re: Loop up and pull a list of data from 1 cell

    @ PCI
    A filter in sheet2 is not possible ?
    Why not...
    Reply With QuoteRegister To Reply
  5. 01-07-2020, 01:46 PM #5
    bordemkills
    bordemkills is offline
    Registered User
    Join Date
    09-20-2016
    Location
    US
    MS-Off Ver
    2010
    Posts
    39

    Re: Loop up and pull a list of data from 1 cell

    Thanks. This is what is happening when I try and run it

    Visual basics pulls up and "Stop is highlighted yellow"
    If Not Intersect(Target, Range("B9")) Is Nothing Then
    Stop

    Is there something I'm doing wrong? I copy pasted the code into Sheet 1 and tried the one you attached. They are both doing the same thing
    Reply With QuoteRegister To Reply
  6. 01-07-2020, 01:47 PM #6
    bordemkills
    bordemkills is offline
    Registered User
    Join Date
    09-20-2016
    Location
    US
    MS-Off Ver
    2010
    Posts
    39

    Re: Loop up and pull a list of data from 1 cell

    The data I need is being pulled from several tabs, If I get this data pulled I can have the other columns I need data for pulled with just a Vlookup
    Reply With QuoteRegister To Reply
  7. 01-07-2020, 01:53 PM #7
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Loop up and pull a list of data from 1 cell

    Else try next code, to be launched from sheet1
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 01-07-2020, 01:56 PM #8
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,210

    Re: Loop up and pull a list of data from 1 cell

    My bad...was testing...delete the STOP...
    or use V2 upload
    Reply With QuoteRegister To Reply
  9. 01-07-2020, 01:58 PM #9
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Loop up and pull a list of data from 1 cell

    Another one acting in sheet2
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  10. 01-07-2020, 02:14 PM #10
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Smile Re: Loop up and pull a list of data from 1 cell

    And for the same price, see next code to prepare a validation list for cell B9
    This macro is fired each time the file is opening
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by PCI; 01-07-2020 at 02:31 PM. Reason: File attach added
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Loop through a data validations list and for each loop count the number of occurences
    By waimea in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-08-2018, 05:22 AM
  2. vba code to pull data from all pages in loop from webpage.
    By xlhelp7 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-08-2017, 06:59 AM
  3. [SOLVED] If cell blank don't allow data validation via a pull down list in a next cell
    By cwby44 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-23-2014, 11:30 AM
  4. make unique list from a list without duplicates but hold cell and pull corresponding dates
    By BRIZZLE101 in forum Excel General
    Replies: 1
    Last Post: 04-19-2013, 02:25 AM
  5. Pull data using loop in another workbook
    By codesRus in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-17-2012, 03:47 PM
  6. Loop to lookup a list names, match them on another worksheet and pull specific header
    By krayl in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2012, 04:15 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1