I have 6 columns and 5 rows of data I need a macro to compare the data in pairs. So if the data in A2 is greater than 30 and the data in B2 is greater than 30 then put the word “Pass” into A7 or “Fail” in A7 if not true. I need this to repeat for pairs C2 and D2, and E2 and F2. Then repeat the same for the remaining rows,see the attached example.
Any help would be greatly appreciated!
Thanks
Jim
Bookmarks