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
Something like:
Sub insert() Do Until n = Range("S2").Value Rows(3).insert n = n + 1 Loop End Sub
!If all your troubles are solved, then so is the thread. Show this by marking it so using thread tools at the top of the page.
If I helped do this, then please show your appreciation by awarding rep points.
<------ Button for that is over there
Assuming you wanted these rows inserted at row 3
Sub insertrows() Range("S3").Resize(Range("S2").Value).EntireRow.insert End Sub
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
Which value are you trying to take from columns N-R?
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks