form serial number

S

solarflareltd

Hi All,

Can someone help please, after weeks of searching and do not know anything
about macros i am now at my witts end.

I use an excel form to generate a customer report following a service visit
and i need to enter a unique number for each form i complete. is there a easy
way (macro) that will generate a unique serial number each time i open the
excel sheet?
 
N

Niek Otten

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi All,
|
| Can someone help please, after weeks of searching and do not know anything
| about macros i am now at my witts end.
|
| I use an excel form to generate a customer report following a service visit
| and i need to enter a unique number for each form i complete. is there a easy
| way (macro) that will generate a unique serial number each time i open the
| excel sheet?
 
S

solarflareltd

Niek Otten said:
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi All,
|
| Can someone help please, after weeks of searching and do not know anything
| about macros i am now at my witts end.
|
| I use an excel form to generate a customer report following a service visit
| and i need to enter a unique number for each form i complete. is there a easy
| way (macro) that will generate a unique serial number each time i open the
| excel sheet?


thanks
Click to expand...

I works a treat!
 
Top