Create Unique Reference

[gtudor]

Morning,

I was wondering if there is a way to create a unique reference to track purchase order receipts (GRN number).

I have enclosed a sample work book. What I am trying to achieve is when a purchase order is received in column I a unique reference is displayed within column J

Long shot..........also, if an item is part shipped is there a way to add another unique reference to column K once the quantity is updated within column I ?

[AndyLitch]

SAMPLE.xlsm

first part solved.... don't understand your requirements for the second part

[gtudor]

Thank you - that is great. I can't see the formula though to copy into my own sheet.

Can you send it me via forum post.

[AndyLitch]

It isn't done with a worksheet formula it's VBA.

The worksheet code module now has this in it :-

Please Login or Register  to view this content.

If you copy the above code into any worksheet code module it will do the same .. The reference number is taken from the time and date which is unique second by second

[gtudor]

Thank you - I have never done anything with VBA but will give it a try.