Results 1 to 14 of 14

Copy and Paste with certain criteria

Threaded View

rizmomin Copy and Paste with certain... 07-30-2014, 01:46 PM
AB33 Re: Copy and Paste with... 07-30-2014, 02:14 PM
rizmomin Re: Copy and Paste with... 07-30-2014, 02:21 PM
AB33 Re: Copy and Paste with... 07-30-2014, 02:38 PM
rizmomin Re: Copy and Paste with... 07-30-2014, 03:50 PM
AB33 Re: Copy and Paste with... 07-30-2014, 04:05 PM
rizmomin Re: Copy and Paste with... 07-30-2014, 04:48 PM
rizmomin Re: Copy and Paste with... 07-30-2014, 09:53 PM
AB33 Re: Copy and Paste with... 07-31-2014, 05:38 AM
rizmomin Re: Copy and Paste with... 07-31-2014, 10:52 AM
AB33 Re: Copy and Paste with... 07-31-2014, 11:00 AM
rizmomin Re: Copy and Paste with... 07-31-2014, 11:20 AM
rizmomin Re: Copy and Paste with... 07-31-2014, 08:42 PM
rizmomin Re: Copy and Paste with... 07-31-2014, 10:58 PM
  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Copy and Paste with certain criteria

    Hello:


    Please refer to attached file.

    I have excel file with data from A1:T31.

    I need a VB macro or Formula to do the following:

    Need to check the value in column L.
    If value is greater then zero then copy corresponding cell from N:T in sheet2 as shown.

    In the attached example since L2 > 0 then i would need to copy and paste in Sheet2 at A2
    In the attached example since L3 = 0 then skip.
    In the attached example since L4 > 0 then i would need to copy and paste in Sheet2 at A3

    asn so on...

    Let me know if you have any questions.
    Thanks.
    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: 0
    Last Post: 10-29-2013, 09:38 AM
  2. [SOLVED] Copy and Paste with criteria
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-05-2013, 12:25 AM
  3. [SOLVED] Copy paste depending on certain criteria (VBA)
    By bonny24tycoon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-23-2012, 07:59 AM
  4. Copy and Paste Based on Criteria
    By jadown in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-24-2011, 04:14 PM
  5. Copy and paste from one sheet to another if the criteria met
    By wali in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-12-2009, 04:25 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