Results 1 to 8 of 8

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

Threaded View

  1. #1
    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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1