Macro help

[dmr3796]

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"

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!

 

[Fluff]

Is this just a continuation of
https://www.mrexcel.com/forum/excel...to-insert-column-given-match.html#post4904130