Hey everyone, thanks in advance for the help.
So I have 2 workbooks, and 1 worksheet in each one. Workbook1 is used for calculations and has all kinds of formulas and things and works as it should. I want to use workbook2 to check the results of the formulas from workbook1. Workbook2 will simply be a list of all of the expected values for the formulas from workbook1. I need to write a simple macro that will simply go down the list in workbook2 and see if the numbers match the values that should be present in each respective cell in workbook1. All I need is a simple pass-fail: if they match, move on to the next one. If they dont, then stop the macro and spit out an error message.
I'd imagine this could probably be solved with some sort of if-then and/or do-while loop?
I've never written a macro on Excel before, so that's why I'm asking for help. Any advice would be very much appreciated. Thank you again, in advance.
--BA Patterson.
Bookmarks