Checking numbers across various sheets
Hi
Im trying to chk numbers if they match between sheets. I have 7
sheets in the workbook. Is there a way to put the statement below
from sheet1..sheet7?
This formula would be on sheet8 where the person would enter the
number again to confirm its correct!
=IF(NOT(Sheet1!$A1=Sheet1!$B1),"numbers do not match","")
Thanks
Mike
|