Hey All,
Im searching for a macro that will find matches based off a certain lookup value, and auto insert a row underneath for multiple matches.
The sheet where the macro will take place will look as such starting with column A: "Sheet1"
<tbody>
</tbody>
This is the sheet that's going to be searched: "Sheet2"
<tbody>
</tbody>
I want the macro to search sheet2 for "Lookup values" and return the values in the "I want this" columns inside of the "return 1 & 2" columns
Additionally, where this gets tricky is that some lookup values have MULTIPLE matches. If there is 2 matches I want a row inserted under to accomodate the second match, placing all the return values in the same columns as specified above.
***Columns labeled as "x" IN 'SHEET1' contain data that MUST align to the respective lookup value, so it's important that if a new row is inserted due to multiple matches, that the row extends PAST those "x" columns to keep the data aligned**
Please let me know if I can clarify further!
Im searching for a macro that will find matches based off a certain lookup value, and auto insert a row underneath for multiple matches.
The sheet where the macro will take place will look as such starting with column A: "Sheet1"
Lookup Values | x | x | x | x | x | x | x | Return 1 | Return 2 | x | x | x | x |
<tbody>
</tbody>
This is the sheet that's going to be searched: "Sheet2"
Lookup Values | x | I want this | I want this | x | x | x | x | x | x | x | x | x | x |
<tbody>
</tbody>
I want the macro to search sheet2 for "Lookup values" and return the values in the "I want this" columns inside of the "return 1 & 2" columns
Additionally, where this gets tricky is that some lookup values have MULTIPLE matches. If there is 2 matches I want a row inserted under to accomodate the second match, placing all the return values in the same columns as specified above.
***Columns labeled as "x" IN 'SHEET1' contain data that MUST align to the respective lookup value, so it's important that if a new row is inserted due to multiple matches, that the row extends PAST those "x" columns to keep the data aligned**
Please let me know if I can clarify further!