Results 1 to 12 of 12

MACRO for searching column for a letter and Copy/Paste the row into new MASTER sheet

Threaded View

  1. #1
    Registered User
    Join Date
    10-17-2013
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    9

    MACRO for searching column for a letter and Copy/Paste the row into new MASTER sheet

    Can someone please point me in the right direction, I am totally lost.....

    I need a MACRO that will search for the letter "x" in a certain column, and if found then copy and paste the row of information associated into a MASTER sheet. The tabs are not named the same but are identical in layout. Search would start at the 8th row of each sheet. This needs to be done for multiple worksheets in the same workbook. I have attached a workbook of what I need.

    Note the U004 & U005 are the sheets that I need information from. Going into the master sheet. Wherever there is an "X" in column X, I need that row pasted into Master.

    Thanks for the help in advance
    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. Replies: 11
    Last Post: 05-12-2013, 11:30 AM
  2. [SOLVED] Macro Copy, Paste Transpose to Master Sheet
    By dingo7448 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-02-2013, 04:15 PM
  3. Help with Copy and Paste Macro from Master sheet to other sheets
    By Livetorace27 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-11-2013, 03:19 PM
  4. [SOLVED] Macro to copy paste Tables to Master sheet
    By dawnmau in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-02-2013, 06:48 PM
  5. Select all sheet copy paste as value & except Master 1 & Master 2
    By tek9step in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-29-2010, 06:49 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