+ Reply to Thread
Results 1 to 2 of 2

Copy range if target cell has value

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    04-14-2014
    Location
    Philippines
    MS-Off Ver
    2007, 2010, 2013, 2016.
    Posts
    169

    Copy range if target cell has value

    Hi.
    Need VBA help.
    I like minimalistic work. see attached worksheet,
    initially what is visible will be A1:D11. (sample in sheet1)
    If D11>0 then copy similar range in A13:D23. leaving B:B blank.
    if total amount is present again with the new range. copy range again and so on.
    please refer to sheet2.
    Thank you in advance for the help.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    04-14-2014
    Location
    Philippines
    MS-Off Ver
    2007, 2010, 2013, 2016.
    Posts
    169

    Re: Copy range if target cell has value

    Hi again.

    Or to simplify,
    if D11>0, Copy Range L1:O11 to next 2nd row, in this case A13
    continue process if criteria is met.
    if D11=0, no copying needed.
    Thanks.
    Attached Files Attached Files

+ 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. [SOLVED] VBA Disbale Copy&Paste in target range (not complete sheet/workbook)
    By RobGER in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-27-2020, 04:25 AM
  2. Replies: 5
    Last Post: 12-16-2014, 05:47 PM
  3. Replies: 5
    Last Post: 01-22-2013, 11:38 AM
  4. [SOLVED] Worksheet_Change(ByVal Target As Range) - set to only update when 3 target cells changed?
    By trillium in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-07-2012, 06:40 PM
  5. Replies: 1
    Last Post: 10-14-2012, 09:25 AM
  6. if copy target range full - copy to new range
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-06-2012, 09:34 AM
  7. Worksheet_CHange (ByVal Target as Range) when target is formula cell
    By coasterman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2012, 07:00 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