Need Help on VLookup Macro

[okcjeremy]

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

[okcjeremy]

This is the code I started with. It has some errors:

Sub Macro1()
Dim sourcelastrow As Long
Dim outputlastrow As Long
Dim sourcesheet As Worksheet
Dim outputsheet As Worksheet

'names of worksheets
Set sourcesheet = daily_drivercheck_rev2.xlsx("daily_check")
Set outputsheet = route_rec_recap_sheet_OKC - Tulsa.xlsx("route_check-in_sheet_okc")

'determine last row of source
With sourcesheet
sourcelastrow = .Cells(.Rows.Count, "A").End(x1Up).Row
End With
With outputsheet
'determine last row in col C
outputlastrow = .Cells(.Rows.Count, "C").End(x1Up).Row
'Apply our formula
.Range("C1:C" & outputlastrow).Formula = _
"=vlookup(A2, '" & sourcesheet.Name & "'!$A$2:$B$" & sourcelastrow & ",2,0)"
End With


' Macro1 Macro
'

'
End Sub

[LordLoki]

Would like to Help you but i don`t understand what exactly needs to be copied from A to B.
Could you explain little bit more detailed what Data goes from Where to Where? Or post an Example of the to Sheets as they are now?

Greets
Loki

[okcjeremy]

Hope this helps.Screen Shot 2015-04-23 at 8.07.44 AM.pngScreen Shot 2015-04-23 at 8.08.18 AM.png

I hope the pictures do justice, however what is happening on worksheet A is it is pulling in "changes" from the defaults and do a conditional formatting to yellow. Currently we do a manual copy to the same route number, ie va1, va2, va3, etc., that is located on sheet B. Sheet B lives in a different folder everyday, so the coding will have to live in Sheet A.