Creating Rows with Numbers According to Cell Value

[loklok95]

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!

[samba_ravi]

Hi welcome to the forumAttach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.