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?

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"solarflareltd" wrote in message
...
| 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?

"Niek Otten" wrote:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"solarflareltd" wrote in message
...
| 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

I works a treat!