unic no
 

Hi Everyone
I Have a user form for staff entry and i want to have a unic no automatically attribute to each staff member that i enter
\example
\cell B1 Name cell B1 surname Cell C1 Address-----up to cell G1 and in cell H1 automatically a number is generated

\thanks for ur usual help
Bakar

unic no
 

Hi

In Cell H2 put this:

=IF($A2="","",1)

In Cell H3 put this:

=IF($A3="","",($H2+1)) then copy down as required.

HTH
Mick.