Create Multiple Rows based on Value in Cell

[ertweety]

Hi There,

I have an excel worksheet that is manually updated by several individuals in the sales field. The purpose is to collect potential loans for the business. Column N on the attached document displays the # of Funding Distributions over the life of the loan. Whatever the number is I need a formula to copy the row that exact number of times to a new spreadsheet. For instance, for the first record of $125,000, I need it to copy the record 6 times to a new spreadsheet.

One last catch, the 'Funding Date' column M needs to update with each record. Since there are 6 records that need to appear on the new spreadsheet, the first record needs to be the 'Funding Start Date Month', (column J) and state Mar-12. The remaining 5 records need to be increased by 1 month.

Make sense? I hope so. I could really use some help on this one.

[jaslake]

Hi ertweety
When you say

copy the row that exact number of times to a new spreadsheet

Are you saying you want a new workbook created for that row? Or only a new worksheet? In either case, how will the worksheet/workbook be named?