Excel to copy rows of the same unique ID and their values to another workbook

[tiffyng]

Hello,

I have 2 workbooks that I would like to link and do some automation. I would like to copy all rows with the same ID (Cindy) and their values from one workbook to another workbook with a spreadsheet named Cindy and Kim to a spreadsheet named Kim.

Any help is appreciated. 

[#2]

https://techcommunity.microsoft.com/t5/excel/autofill-select-rows-from-one-sheet-to-another/m-p/4073...