Results 1 to 6 of 6

copy a cell multiple times depending on cell value starting on a specific cell

Threaded View

  1. #1
    Registered User
    Join Date
    08-16-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    3

    copy a cell multiple times depending on cell value starting on a specific cell

    Hello!

    I am trying to copy/paste a cell a number of times depending on the value of another cell (B2) starting in a specified cell.
    The specified cell depends on the month and year the user inserts on the spreadsheet.

    So the cell to be copied is on cell A3, and the number of times it should be copies is on cell B3.
    Columns on the right are labeled with years and months, and according to the month and year specified by the user (cell C3 and cell D3) the starting cell.

    Example:
    I need to be displayed $10,000 3 times, starting in the column corresponding to October 2013 (column f) and the next 2 (column G and H) to make a total of three.
    Need to be display $20,000 2 times, starting in column January 2014 (column I) and the next column (column J) to make a total of two.

    A B C D E F G H I J K
    1 Amount Period Starting month Starting year 2013 2013 2013 2013 2014 2013 2014
    2 September October November December January February March
    3 $10,000.00 3 October 2013
    4 $20,000.00 2 January 2014


    Result:

    A B C D E F G H I J K
    1 Amount Period Starting month Starting year 2013 2013 2013 2013 2014 2013 2014
    2 September October November December January February March
    3 $10,000.00 3 October 2013 10,000 10,000 10,000
    4 $20,000.00 2 January 2014 20,000 20,000


    Hope I was clear enough.
    Thank you!
    (document attached)
    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. Macro that is column specific & changes cell color depending on cell contents
    By zurispowell in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-25-2012, 05:03 PM
  2. Fill specific cell depending on the number provided in a cell
    By ifticalgary in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-25-2011, 03:13 PM
  3. Replies: 5
    Last Post: 09-30-2010, 01:50 PM
  4. Copying specific cell ranges from a worksheet multiple times to a new sheet
    By kaz8772 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-10-2009, 03:54 PM
  5. [SOLVED] how do i copy the same cell multiple times in excel.
    By andy in forum Excel General
    Replies: 1
    Last Post: 07-06-2006, 07:55 PM

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