Hi, I am new to this forum and searched for similar questions but none seem to work for me.

I am looking for the following to happen in a macro:
Sheet1 column with unique number id's (and other columns with details)
Sheet2 3 columns where the third column has text and numbers where the sheet1 numbers could show up.
Sheet1 ids can be included in multiple Sheet2 entries.
I like the Sheet2 entries copied to the first empty column/field/row in Sheet1, listing multiple entries on seperate rows, inserting rows as needed.
When a sheet1 id is not found nothing should happen, just show original row

Search unique value from one worksheet in another & copy details - macro.xlsx

The result can be included in sheet1 or in a new sheet if easier



Thanks in advance for your help

Jacqueline