All I really want to know is how to change the activesheet to a different worksheet.
I also want to confirm that to lookup values in another workbook I would simply create a variable of type workbook and set that variable to the path of the workbook, correct?
Dim wkbTest as Workbook
wkbTest = "c:test.xls"
Is that right?