Results 1 to 2 of 2

macro to copy a row based on a value in a cell and change some values in the copied row

Threaded View

  1. #1
    Registered User
    Join Date
    11-14-2014
    Location
    Kansas
    MS-Off Ver
    2013
    Posts
    4

    Lightbulb macro to copy a row based on a value in a cell and change some values in the copied row

    I need a macro to duplicate based on a cell value in column H. If the value is 456 for example, then I need the line to be copied 4 times, if the value is 230, then I need the line to be copied 2 times. (the number of times copied is based on the first number of the series of numbers). If the number in column H is less than a 100 then i don't need that row to be copied. Then I would need it to change the value in column J to an incrementing value of +1. I would then need column O to take the value of the cell above and minus it from the P cell next to it. For example the copied cell would have "=02-P2" Sorry if this is hard to understand. would you be able to help me with this? The photo below demonstrates what I would want it to do. (the values in columns change)
    Screen Shot 2014-11-14 at 9.07.50 PM.png
    Last edited by cmedved07; 11-15-2014 at 12:04 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to change cell values based on changes in another worksheet
    By joee0201 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-02-2014, 03:29 PM
  2. Need help making a macro to copy range of values based on cell values.
    By zolton in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-23-2013, 08:58 AM
  3. paste RNG numbers
    By kaohik78 in forum Excel General
    Replies: 0
    Last Post: 09-26-2012, 10:30 PM
  4. [SOLVED] Macro to copy above row and insert copied row based on value
    By sambuka in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-06-2012, 06:24 PM
  5. [SOLVED] Macro to change values of a cell based off another cell
    By krazyjoker in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-27-2012, 12:45 AM

Tags for this Thread

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