I use the following formula to match data between sheet1 and sheet2 of my workbook;
=A2&" Found in row "&MATCH(A2,Sheet2!$A$1:$A$1000,0). The formula works fine but,
when i cut data from a source workbook and paste it into my main workbook, i receive 2 separate error messages 1.Visual Basic Error="File Not Found". 2.MS Excel Error="Cannot Paste Data". Although the data does paste successfully, i get these error messages everytime.
Please advise as to how i can get rid of these error messages.
Thx,
Noir
=A2&" Found in row "&MATCH(A2,Sheet2!$A$1:$A$1000,0). The formula works fine but,
when i cut data from a source workbook and paste it into my main workbook, i receive 2 separate error messages 1.Visual Basic Error="File Not Found". 2.MS Excel Error="Cannot Paste Data". Although the data does paste successfully, i get these error messages everytime.
Please advise as to how i can get rid of these error messages.
Thx,
Noir