Hi Akbar,
Have a look at the attached. Type "Akbar" anywhere on sheet 1
To do the vice-versa thing, enter similar code into the VBA Sheet 3 window.
Regards - Dave.
Date: Thu, 24 Mar 2011 11:36:15 +0500
Subject: $$Excel-Macros$$ How to prevent from duplication in one work
my question is
i enterd the word "Akbar" in the sheet 1 and then i moved towards sheet 3
and there
i m again going to enter "Akbar" at this time excel notify me that i have
already entered the same word in sheet numer 1 at column - and row
-. and also vise versa
plz help me
regards
--
