Check for Duplicate PO# before finalizing...

**Legend Rubber** · 11-09-2012, 07:48 AM

OK... here we go...
Attached is quite an in depth worksheet with a lot of roles and variables... (at least for me

)
What i would like to do, is check (in the Packing Slip Log) to make sure that a Packing Slip for the specified Purchase Order number has not already been entered...
There is a column in the Packing Slip titled Purchase Order #, which is where the PO# is entered...
So when i press the finalize button, i would like it to check(before it performs the other steps) to make sure there is not a duplicate, and prompt me if there is, with the PO# that is a duplicate, and give me a chance to abort finalizing to check.
Also, might be helpful to highlight the duplicate on the Packing Slip Log if user choosing to continue with duplicate...
I am fairly new still, and learning by trial and error, so any suggestions on cleaning up my current code would be helpful as well, as i am sure i go about it the wrong way most of the time

...
So... lets see... who can help?
Attachment 193094

**Jacc** · 11-09-2012, 06:06 PM

I can't see your code, it's password protected.
You can just add an extra column and use a formula like this.

Formula:

=COUNTIF(D3:D100;D3)

but in a application like that the Table feature (under the insert tab) can be useful. I used that in the workbook attached.
The table feature does expand the formulas automatically as data is added.