+ Reply to Thread
Results 1 to 1 of 1

VBA code to copy and paste row based on certain criteria. need help with Paste part

  1. #1
    Registered User
    Join Date
    04-25-2013
    Location
    Zagreb, Croatia
    MS-Off Ver
    Excel 2010
    Posts
    2

    VBA code to copy and paste row based on certain criteria. need help with Paste part

    Dear all,

    Currently I have an excel table where I have a macro that based on a certain value in a cell (> 1), it will copy, insert new row and paste the entire row x number of times based on the value in the column "COUNT".

    What I need help with is I don't want the row to be copied exactly, but based on the value in "COUNT", for each paste the row will contain only one input value with the following pattern. It's hard to explain, so I hope the table below explains it.

    BEFORE
    count input input input
    3 A A A
    AFTER
    3 A A A
    3 A A A
    3 A A A
    3 A A A

    what I would like the macro to do:

    BEFORE
    count input input input
    3 A A A
    AFTER
    3 A A A
    1 A
    1 A
    1 A

    So if the value is 10, I want the macro to copy it 10 times but each row has only one input value if an offset of 1.

    Attached is the excel with the current macro and an example how I wish it works.

    Thank you for your help!

    BR,

    T0NT0
    Attached Files Attached Files
    Last edited by T0NT0; 10-29-2013 at 09:47 AM.

+ 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. Replies: 0
    Last Post: 07-16-2013, 05:22 AM
  2. Code to copy and paste row from one excel sheet to another, based on criteria
    By CamSeren in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-25-2013, 04:32 AM
  3. Copy and Paste Based on Criteria
    By jadown in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-24-2011, 04:14 PM
  4. Copy and Paste Cells based on Criteria
    By GBR2L in forum Excel - New Users/Basics
    Replies: 9
    Last Post: 04-28-2010, 08:13 AM
  5. Filtering and then copy/paste based on criteria
    By Ramthebuffs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-25-2005, 05:12 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