ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Reference numbers (https://www.excelbanter.com/excel-worksheet-functions/119649-reference-numbers.html)

Pasty

Reference numbers
 
Is it possible to get excel to automatically generate reference numbers for
different actions?

Niek Otten

Reference numbers
 
Not clear what you mean by "reference numbers". What should they refer to and how?

But do look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Pasty" wrote in message ...
| Is it possible to get excel to automatically generate reference numbers for
| different actions?



Pasty

Reference numbers
 
Hi,

What I was getting at was - it will be used on a risk register and I when
people put in a new action i would like excel to automatically give it a new
number, but I'm not entirely sure this is possible.

"Niek Otten" wrote:

Not clear what you mean by "reference numbers". What should they refer to and how?

But do look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Pasty" wrote in message ...
| Is it possible to get excel to automatically generate reference numbers for
| different actions?




Niek Otten

Reference numbers
 
Then do check the link I gave you

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Pasty" wrote in message ...
| Hi,
|
| What I was getting at was - it will be used on a risk register and I when
| people put in a new action i would like excel to automatically give it a new
| number, but I'm not entirely sure this is possible.
|
| "Niek Otten" wrote:
|
| Not clear what you mean by "reference numbers". What should they refer to and how?
|
| But do look he
|
| http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
|
| "Pasty" wrote in message ...
| | Is it possible to get excel to automatically generate reference numbers for
| | different actions?
|
|
|




All times are GMT +1. The time now is 09:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com