I want to compare the Value of Cell E23 from Workbook1 to (Here's where it get's hairy) the last row with data in column H of Workbook2. If these values match..then I want to save C:\Files\Daily\ & WB.Name & "Match" & ".xls" If they do not match I want to save C:\Files\Daily\ & WB.Name & "No_Match" & ".xls"

How does VBA check values across worksheets?