+ Reply to Thread
Results 1 to 8 of 8

Macro to pull all rows of data based on an item selected in drop down

  1. 10-13-2015, 06:14 PM #1
    owensjb2
    owensjb2 is offline
    Registered User
    Join Date
    05-08-2010
    Location
    AZ
    MS-Off Ver
    Excel 2007
    Posts
    49

    Macro to pull all rows of data based on an item selected in drop down

    Hello,

    I am trying to create a macro that will comb through a sheet of data looking for a specific string. The string will be found by selecting it via a dropdown located on the "Consolidated Schedule" Tab. The macro will then search through all cells for that string on the "Tracker" tab. Cells for the entire row will then be copied and pasted to the "Query Results" tab.

    Please see the attached sample data.

    Thank you in advance for your support!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-13-2015, 07:04 PM #2
    Trebor76
    Trebor76 is offline
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,525

    Re: Macro to pull all rows of data based on an item selected in drop down

    Hi owensjb2,

    Try this:

    Please Login or Register  to view this content.
    Regards,

    Robert
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
    Reply With QuoteRegister To Reply
  3. 10-13-2015, 07:07 PM #3
    stnkynts
    stnkynts is offline
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Macro to pull all rows of data based on an item selected in drop down

    Will automatically run when a change in cell A1 occurs

    Please Login or Register  to view this content.
    If you are happy with my response please click the * in the lower left of my post.
    Reply With QuoteRegister To Reply
  4. 10-13-2015, 07:18 PM #4
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,525

    Re: Macro to pull all rows of data based on an item selected in drop down

    Try
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by jindon; 10-13-2015 at 10:15 PM. Reason: File attached
    Reply With QuoteRegister To Reply
  5. 10-13-2015, 07:21 PM #5
    Trebor76
    Trebor76 is offline
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,525

    Re: Macro to pull all rows of data based on an item selected in drop down

    Hi stnkynts,

    I think (could be wrong) you'll need to loop through each "Description" column (i.e. K, N, Q and W) in the Tracker sheet for your nifty macro to be complete as the text in cell A1 of the Consolidated Schedule tab can appear in each of these columns.

    Robert
    Reply With QuoteRegister To Reply
  6. 10-13-2015, 08:19 PM #6
    LeoTaxi
    LeoTaxi is offline
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Macro to pull all rows of data based on an item selected in drop down

    Or

    Please Login or Register  to view this content.
    Kind regards
    Leo
    Reply With QuoteRegister To Reply
  7. 10-13-2015, 10:08 PM #7
    LeoTaxi
    LeoTaxi is offline
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Macro to pull all rows of data based on an item selected in drop down

    Or

    Please Login or Register  to view this content.
    Kind regards
    Leo
    Reply With QuoteRegister To Reply
  8. 10-14-2015, 10:35 AM #8
    stnkynts
    stnkynts is offline
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Macro to pull all rows of data based on an item selected in drop down

    @Trebor. You could be right. I just assumed they were talking about column K. Oh well.
    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. Sheet recalculates based on item selected on drop-down box?
    By TwistedFaith in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-12-2015, 07:21 PM
  2. Macro delete submit button when item selected from drop dowm list
    By vnoelte in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-05-2014, 12:33 PM
  3. Pull data from another Worksheet when drop down items are selected
    By Kensie in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-21-2014, 09:53 PM
  4. Run macro when item from drop-down list is selected
    By barnett2000 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-09-2013, 12:52 PM
  5. [SOLVED] Formula to pull in figures up to a point based on the month selected in a drop down box
    By The_Snook in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-04-2012, 09:39 AM
  6. [SOLVED] Link to item (row) selected in drop down (data validation)
    By stlchristy77 in forum Excel General
    Replies: 3
    Last Post: 06-26-2012, 03:07 PM
  7. Calculate Based on Drop Down Item Selected
    By JenB in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-18-2006, 12:45 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