Link to home
Start Free TrialLog in
Avatar of NYANBCNY32
NYANBCNY32Flag for United States of America

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?
Avatar of Gregory Miller
Gregory Miller
Flag of United States of America image

Hmmm... Maybe you could post an example of the spreadsheet. That would help clarify your question.
Avatar of NYANBCNY32

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
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
Avatar of Flyster
Flyster
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
This worked perfect! Thank you!