Thanks Catalin for the reply. Can you please apply the formula in the sample .xls file in my query. I am getting an error when i pasted the formula as there is no A4 and B4 cells. Will appreciate too if you can show the message reminder when the user clicks the sheet2 tab. Good day