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 book From: sh.talal.ak...@gmail.com To: excel-macros@googlegroups.com 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 -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Where's Akbar.xls
Description: MS-Excel spreadsheet
