Im new to VBA and im trying to write a code to skim through 2 columns. if value 1 from column A match with a value 2 from column B but is on a different row, it would copy from value 1 to the rest of the column A and move down to match with value 2 on Column B.

This is a sample of the starter sheet

This is what the macro should do

I’ve look over various ways to try and move the column, either by using for loop or using functions like .copy or .Insert Shift:=xlDown. but i have no luck with the logic.