I am new to this world, please bear with me. I have two sheets (Sheet 1 and Sheet 2), On column E of Sheet 2 , I have data that needs to prevent from duplications. So I used the data validation with countif formula on Sheet 2 (Col E) which works fine. However if I insert the data from Sheet 1 and linked to Sheet 2 column E (using vba cell referencing), it doesn't work anymore and it accepts the duplicate value. How my expectation can be achieved ? Any codes or other formulas?
Thanks,
Thanks,