+ Reply to Thread
Results 1 to 4 of 4

Copy and paste row based on cell value

  1. #1
    Forum Contributor
    Join Date
    04-16-2014
    Location
    Witbank, SA
    MS-Off Ver
    Excel 2013
    Posts
    268

    Copy and paste row based on cell value

    Hi good people!,

    I know, there are many posts on this issue, and believe me, I have spent a whole lot of time searching, found a few solutions, but still not any that match my need. Please help.

    This is simple, just a code that will copy the row from column A to column L, if the value in column M is 1. The amount of rows are I million, so it searches M1 to M1000000, find a "1", then copies the row (A-L) to sheet2. Just a NOTE: it has to look for all the 1's in column M. Also, the pasting needs to be done using the first available rows in sheet 2. All and any help is as always greatly appreciated. Thank you..

  2. #2
    Registered User
    Join Date
    09-10-2014
    Location
    Matrix
    MS-Off Ver
    2010
    Posts
    70

    Re: Copy and paste row based on cell value

    Use this code:
    Please Login or Register  to view this content.
    I think you have headers so that it starts from row 2.
    Last edited by michson; 01-22-2015 at 04:17 AM.
    (*) Reputation points appreciated.
    excelbs.tk

  3. #3
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480

    Re: Copy and paste row based on cell value

    Try this,
    Please Login or Register  to view this content.
    Last edited by davesexcel; 01-22-2015 at 04:25 AM. Reason: Edit Code

  4. #4
    Forum Contributor
    Join Date
    04-16-2014
    Location
    Witbank, SA
    MS-Off Ver
    Excel 2013
    Posts
    268

    Re: Copy and paste row based on cell value

    Hi Michson and davesexcel,

    Thank you both guys. Both codes work perfectly!!. Now just one problem...which one do I use?... Have a great day!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA copy and paste based on cell value
    By Simon.xlsx in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-09-2014, 12:51 PM
  2. Copy and Paste based on a cell value
    By lzee61971 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-17-2014, 09:59 PM
  3. Copy-Paste based on cell value
    By Konexcelmath in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-30-2013, 03:32 AM
  4. [SOLVED] Copy/Paste Based on Value of Cell
    By l8tnite in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-25-2012, 06:17 PM
  5. Copy Paste based on Cell Value
    By Bwbisel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-14-2011, 09:06 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