Results 1 to 10 of 10

Copy and paste row based on cell value

Threaded View

  1. #1
    Registered User
    Join Date
    09-23-2010
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    23

    Copy and paste row based on cell value

    Hi all,

    I have a workbook with a worksheet ("work1") with names in Column A and serial numbers in Column B.

    In this workbook is a second worksheet ("work2") with another list of serial numbers.

    I need the macro to look for serial numbers in work1 (column B) from work2.

    If cell is found, cut row out of work1 and paste in new worksheet.

    Thanks!
    Last edited by contra76; 10-18-2010 at 10:03 PM. Reason: clarity

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