+ Reply to Thread
Results 1 to 5 of 5

Copy values down by given factor

  1. 02-03-2014, 09:50 AM #1
    FixandFoxi
    FixandFoxi is offline
    Registered User
    Join Date
    06-06-2012
    Location
    Switzerland
    MS-Off Ver
    MS Excel 365
    Posts
    68

    Copy values down by given factor

    Hi all,

    Please see attached file. I am looking for a macro which can copy/paste down a value (column A) by a given factor (column B). The result should be a list of all values (column C). The amount of values and factors is unknown (the attached example ends at row 5). Any idea or existing solution?

    Many thanks for your inputs (!),
    FixandFoxi
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-03-2014, 10:28 AM #2
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Copy values down by given factor

    Try the attached.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 02-03-2014, 11:03 AM #3
    Winon
    Winon is offline
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Copy values down by given factor

    Hello FixandFoxi,

    Personally, I think that what AB33 has given you deserves a reputation "Tap".

    Regards
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
    Reply With QuoteRegister To Reply
  4. 02-05-2014, 03:23 AM #4
    FixandFoxi
    FixandFoxi is offline
    Registered User
    Join Date
    06-06-2012
    Location
    Switzerland
    MS-Off Ver
    MS Excel 365
    Posts
    68

    Re: Copy values down by given factor

    Brillant, another man of genius, as so many in this forum!!! Many thanks for your great work!!!

    FixandFoxi
    Reply With QuoteRegister To Reply
  5. 02-05-2014, 06:47 AM #5
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Copy values down by given factor

    FixandFoxi,

    You are welcome!
    Winon,
    Thank you very much!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Use row number as factor in calculation, replace original values
    By margieh204 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-30-2013, 06:49 PM
  2. The 'WOW' Factor
    By Hopefull in forum Excel General
    Replies: 1
    Last Post: 09-11-2011, 04:07 PM
  3. bradford factor
    By Tjenkins in forum Excel General
    Replies: 8
    Last Post: 10-29-2010, 06:38 AM
  4. [SOLVED] IF FACTOR?
    By Bernadette in forum Excel General
    Replies: 2
    Last Post: 06-08-2006, 09:20 AM
  5. [SOLVED] multiply all values in all cells by a factor
    By [email protected] in forum Excel General
    Replies: 1
    Last Post: 03-14-2006, 05:55 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1