i need to compare cell values A1=102 and B1=102 ......If they match then copy b1 and paste in another cell....or, say B1=105 wait till it matches andf then post the entry in another cell can anyone help.....how to do this waiting and also prevent the formula to recalculate and when the cell values change I need this formula to genrate only one match and then subsude....