Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 Last edited by Bakar : November 13th 12 at 04:28 PM Reason: Solved |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|