Re: $$Excel-Macros$$ To avoid repetitions of figures in the same column

2010-11-03 Thread P.VIJAYKUMAR
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.

$$Excel-Macros$$ To avoid repetitions of figures in the same column

2010-11-03 Thread Anubhav Somani
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.. followe