Comparing Cell Across Worksheets

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?

I am toying with this code:

Please Login or Register  to view this content.

Do the experts here see any issue with this? (I am still testing it trying to customize it to my needs, and it's a lot harder than I thought it would be)

Comparing values in workbooks that are not open to my knowledge cannot be done - the workbooks need to be open. You could check to see if workbook is open and if it is not open then you could open it. The following code goes into a module in Workbook1

Please Login or Register  to view this content.

To check if the second workbook is open you would use something like

Please Login or Register  to view this content.

Just place this macro in a module in Workbook1 = this saves workbook2 as either match or no match - you can alter the code if it is Workbook1 you want to save.

Anthony
“Confidence never comes from having all the answers; it comes from being open to all the questions.”
PS: Remember to mark your questions as Solved once you are satisfied and rate the answer(s) questions.”

I am trying to implement this piece into a larger project that I am running. I can't wrap my mind around how to add this into my process, because I am using an array, to cycle through workbooks, but I don't want to leave that many workbooks open. Or add in at the end to re-open each workbook, just to compare the data. This is my current procedures:

Please Login or Register  to view this content.

I want to compare E22 of Hoop1 to LastCell of H in Hoop2 --- is there a way to just add this new process into my current process?

What is the purpose of the Sub Hoop1 - are you trying to rename it - your problem will be that with Set wb - there is no wb.name so this will cause an error.
What are the two file names you want to compare or are there multiple files you want to compare. As it stands your above code should fail in the first sub. I thought you just wanted to compare the value of E22 in one workbook to the value if the last cell in Column H of another workbook or do you want to check it against multiple workbooks - there is no need to have multiple workbooks open - however you will need to open a workbook to get values - perhaps I am not understanding what you are after - if you could be very specific with what you want and the file names I could help you more.
Just confirm as well you are using Excel 2000?

Yes this is Excel 2000.

It is based off of multiple workbooks, for Example, I want the values in E22 Mountain Hoop1 to match the last row of H in Hoop3, and then the same for River, and the same for stream.