Generate Table excel with determinate input

[ToseSenpai]

Hi all,

Can i ask you if i can generate an excel table with determinate input?
I attach an image for better explain:

As you see, when i insert a value (row of table), its possible to generate the rows like the image?
That will help me for the data entry, cuz i dont want to leave free cells of the table !

Ty all for the help !

 

[ToseSenpai]

Anyone can help me?

 

[ToseSenpai]

I found the solution for anyone interested about this thread ! ?

With this VBA code you can add/insert row with a input box that resolve my problem !
You can decide to insert new rows or copy them from another positions !
Unfortunately I didn't find a method to dynamically fit rows to cell value like in the picture but i'm satisfied !
Have a good day

Sub ROWSNUMBER()

Dim iRow As Long
Dim iCount As Long
Dim i As Long

iCount = InputBox(Prompt:="How many rows you want to add")
iRow = 11
'InputBox _
'(Prompt:="After which row you want to add new rows? (Enter the row number")

For i = 1 To iCount
   Rows(10).copy
   Rows(iRow).Insert Shift:=xlShiftDown
    'Rows(iRow).EntireRow.Insert
Next i

End Sub