Hello,
I'm wondering if there's a way to enter a number into a field and have that many rows created in another part of the sheet? For instance, in the example below, when I replace the "?" with a number I would like that number of rows created under the Jan-13 row, using the same formatting. Is this possible in Excel 2010?
Thanks,
Troy
[TABLE="width: 500"]
<tbody>[TR]
[TD]Step 1[/TD]
[TD]Account Details[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1a[/TD]
[TD]Account Name[/TD]
[TD="align: center"]Template[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1b[/TD]
[TD]Contract Start Date[/TD]
[TD="align: center"]1/1/13[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1c[/TD]
[TD]Number of Months[/TD]
[TD="align: center"]?[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1d[/TD]
[TD]Account Value[/TD]
[TD="align: center"]$XXXX[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1e[/TD]
[TD]Desired Margin[/TD]
[TD="align: center"]2.5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1f[/TD]
[TD]Monthly Cap[/TD]
[TD="align: center"]XX[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Step 2[/TD]
[TD]Labor costs[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Tier Cost[/TD]
[TD]Seat Cost[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD]Jan-13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I'm wondering if there's a way to enter a number into a field and have that many rows created in another part of the sheet? For instance, in the example below, when I replace the "?" with a number I would like that number of rows created under the Jan-13 row, using the same formatting. Is this possible in Excel 2010?
Thanks,
Troy
[TABLE="width: 500"]
<tbody>[TR]
[TD]Step 1[/TD]
[TD]Account Details[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1a[/TD]
[TD]Account Name[/TD]
[TD="align: center"]Template[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1b[/TD]
[TD]Contract Start Date[/TD]
[TD="align: center"]1/1/13[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1c[/TD]
[TD]Number of Months[/TD]
[TD="align: center"]?[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1d[/TD]
[TD]Account Value[/TD]
[TD="align: center"]$XXXX[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1e[/TD]
[TD]Desired Margin[/TD]
[TD="align: center"]2.5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1f[/TD]
[TD]Monthly Cap[/TD]
[TD="align: center"]XX[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Step 2[/TD]
[TD]Labor costs[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Tier Cost[/TD]
[TD]Seat Cost[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD]Jan-13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]