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.
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