Auto-generate sequential numbers

[hnkim]

I am working on a project where I need to have item numbers auto generate into a table, once the user fills in a specifc cell in the title with a number (eg. Site Review No. 2) and the item list would auto generate 2.1, 2.2, 2.3 in the below table. Is this possible? I have searched online and can't find any help.

 

[ExcelElliott]

Would something like this work?

Cell A2 = Site Review No. 2

	A

<colgroup><col style="width: 25pxpx"><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]4[/TD]
[TD="align: right"]2.1[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]2.2[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]2.3[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]2.4[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]2.5[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]2.6[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]2.7[/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]2.8[/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]2.9[/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A4[/TH]
[TD="align: left"]=(RIGHT($A$2,LEN($A$2)-FIND(". ",$A$2))*1)+(ROWS($A$4:A4)/10)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A5[/TH]
[TD="align: left"]=(RIGHT($A$2,LEN($A$2)-FIND(". ",$A$2))*1)+(ROWS($A$4:A5)/10)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A6[/TH]
[TD="align: left"]=(RIGHT($A$2,LEN($A$2)-FIND(". ",$A$2))*1)+(ROWS($A$4:A6)/10)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A7[/TH]
[TD="align: left"]=(RIGHT($A$2,LEN($A$2)-FIND(". ",$A$2))*1)+(ROWS($A$4:A7)/10)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A8[/TH]
[TD="align: left"]=(RIGHT($A$2,LEN($A$2)-FIND(". ",$A$2))*1)+(ROWS($A$4:A8)/10)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A9[/TH]
[TD="align: left"]=(RIGHT($A$2,LEN($A$2)-FIND(". ",$A$2))*1)+(ROWS($A$4:A9)/10)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A10[/TH]
[TD="align: left"]=(RIGHT($A$2,LEN($A$2)-FIND(". ",$A$2))*1)+(ROWS($A$4:A10)/10)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A11[/TH]
[TD="align: left"]=(RIGHT($A$2,LEN($A$2)-FIND(". ",$A$2))*1)+(ROWS($A$4:A11)/10)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A12[/TH]
[TD="align: left"]=(RIGHT($A$2,LEN($A$2)-FIND(". ",$A$2))*1)+(ROWS($A$4:A12)/10)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]