Hi All,

I'm a beginner in excel and have 0 experience in VBA. I've only been taught basic formulas in school.
However, I've chosen to work on simple decision making spreadsheet that requires to do the following function:

Creating and numbering the rows according to a value in the cell.
For example,
sheet 1 cell indicate a value, 36.
sheet 2 to automatically create 36 rows that are numbered (see following example that I did manually)
Screenshot 2018-11-06 at 5.16.48 PM.png

Really need this to complete my project so would really appreciate some step-by-step help here.

Thank you in advance!

Cheers!