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)
Bookmarks