Hi everyone,
Hope I can get some help with this. Please see the description below and attached sample workbook.
What I'm trying to do:
What I'm trying to do is create a macro that will count the number of instances the values in Data column I appear, insert rows below the rows with alphanumeric strings containing the value in Summary column A, and then copy the Data column E values into these new rows if the corresponding column I values equal the searched value.
Data
This sheet contains the data that's going to be used to determine the # of rows that need to be inserted, where they are inserted, and what is to be copied into them.
Summary
This sheet contains alphanumeric strings in column A that contain a value found in column I of sheet1
I have attached a sample workbook. Summary and Data sheets include sample data, and the Desired End Result worksheet is effectively the result I'm trying to reach. Please note, actual column E data in the Data worksheet will contain numbers and letters and will be entirely randomized. Also, Summary column A strings will be a bit longer than what is in the sample workbook.
Any help?
Thanks!!
Bookmarks