Hello everyone, please help me create a macro that will run on bookA which will check the latest dates in sheet1, then find the matching date in bookB sheet1 and copy the entire column into workbook at A at the same matching date.

Attached are revelant sample file.

bookA.xlsx

bookB.xlsx