I am wanting to create a macro where it will do a vlookup on two different workbooks and past the values along with the formatting into a different spreadsheet. This is what I got:

Source worksheet (drivercheck)
Thursday (drop down box)
Column A Column B
Route Driver
V01 John Bailey
V02 Ralph
V03 Sam
etc

Destination worksheet (recap)
Column A Column B Column C
Rt Load # Driver
V01
V02
V03
etc

The macro will have to "live" in the source worksheet as the location of the destination worksheet is a different location everyday. The source worksheet already does a vlookup and does a conditional formatting to highlight the changes. The highlighted changes currently are manually copied over to the destination worksheet. I would like where the macro will take the highlighted changes and copy them over along with the highlighting to the destination worksheet. Therefore what I am looking for is to open both spreadsheets and run the macro to insert the changes into the destination worksheet.

Thank you so much,
Jeremy