+ Reply to Thread
Results 1 to 4 of 4

Search a column for a value if found copy entire row and paste

  1. #1
    Registered User
    Join Date
    11-15-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    29

    Search a column for a value if found copy entire row and paste

    Ok here goes I need a VBA to look at A1 for a value doesnt matter whats in there and to search in a different sheet in Column A for what ever value is in A1 and copy the row and then paste it in a new sheet.
    Thank you
    Last edited by awagenhurst; 12-07-2012 at 03:24 PM.

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,821

    Re: Search a column for a value if found copy entire row and paste

    Hello awagenhurst. Try the following code. It assumes that the first row in Sheet2 and Sheet3 contains the column labels.

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    11-15-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    29

    Re: Search a column for a value if found copy entire row and paste

    Dude you rock!!!!!!!!!!!!!!!!

  4. #4
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,821

    Re: Search a column for a value if found copy entire row and paste

    Glad it worked out!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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