Creating a Macro which inputs # of rows based on cell value

Hi everyone,

Hope you're having a great weekend!

I am attempting to build a macro which generates x amount of rows bases on the number located in a specific cell (S2).

Can anyone provide any support or direction on where I can start? I create/utilize Macros daily, but am stuck with this one. In addition, how can I input a value in those newly created rows, based on a cell value found in the primary row?

Thanks in advance for your assistance!

-Nate

Assuming you wanted these rows inserted at row 3

Please Login or Register  to view this content.

Awesome, thank you to both of you! Now that I have the rows created, how can I take a value found in Columns N-R, and insert it into the cells found in Column C?Macro Help.JPG

Based upon your picture it doesn't look like anything other than Onshore should go in column C

I want to take the numerical values found in columns n-r, and place that many of the associated header of columns n-r, in column C. Can that be done?