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
Bookmarks