NYANBCNY32
asked on
Insert Row(s) in Excel Based on Condition
I'm looking for a way to set a Macro that will insert lines based upon the number that will be pulled into column C from a Data Scrape that will occur in an EXTRA! Session based upon Columns A&B. But also when it inserts the lines it will also copy the information in Columns A&B and set it into each inserted line. Is this possible?
Hmmm... Maybe you could post an example of the spreadsheet. That would help clarify your question.
ASKER
sure thing, attaching it now, ultimately there's going to be an unknown amount of data is A&B where this will need to be run, but C will have the amount of records that will need to have data pulled, so I figured it would be easier if macro could insert and copy the data to the lines to prep for this.
InsertExample.xlsx
InsertExample.xlsx
Can you also show a mock up of how you are describing the data insert. I am going to be honest, I am not following your instructions on what you want to do.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This worked perfect! Thank you!