Hi Anubhav,
You can prevent repetition of PO Numbers by Data validation.First select The PO column.Then in The Data Menu go to Data Validation.in that Select Data Validation option.You will get a dialog box with three options.Select the Settings button.you will get a drop down list under Allow. you select custom in the drop down list.You specify the criteria(your conditions) in the small box given below and press OK . Excel will not allow and repeated number. You can also specify the message to be displayed or error alert to be given in case of any error in the data which is not in conformation to your conditions specified by using the Input Message and error alert options.You can also highlight the data which does not follow your criteria by using the Circle Invalid Data Option. Regards, Vijaykumar On Wed, Nov 3, 2010 at 7:52 PM, Anubhav Somani <anubhav.som...@gmail.com>wrote: > Hi All, > > I have a query. > > I maintain a sheet of Project PO's (purchase orders) and PO numbers go in > 1000's... These entries are done manually and there can be manual error by > which the same number gets repeated. (the entries are not done in serial, > i.e., after PO no. 1, the next can be 12.. followed by 7. ) Hence i want to > avoid the repetition error in PO numbers.. > > Eg. of error: In *row 32* the PO No. is 125 and by manual error again in *row > 200* the PO No. is 125. > > > The sheet's various columns are like: > > *Sl / Party Name / PO No./ Date / Details / Amount* > * > * > Here my main concern is PO number. And i want to ensure that this no. does > not get repeated. Is there any way by which there can be a flag or signal > that its getting repeated > > Request your suggestions.. > > Regards, > Anubhav > -- > > ---------------------------------------------------------------------------------- > 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- P.VIJAY KUMAR -- ---------------------------------------------------------------------------------- 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
