Can you automate numbers in Excel?
I need a number to automatically populate a cell with a unique number each time the worksheet is opened. The number being populated needs to populate in numerical order. For example, I have a worksheet that is being used as a form which requires a unique number to be used as the "ticket number". Each time the form is pulled up and used in Excel as an official "ticket", it needs to have a different number; each subsequent ticket shall follow the ticket number before it. The first ticket number would be 1. Then when the same form was opened up to be used the second time, the ticket number would be 2 and so on. Can such a function be accomplished in Mircrosoft Excel? Thanks in advance. Heather Stokes -- Heather Stokes ------------------------------------------------------------------------ Heather Stokes's Profile: http://www.excelforum.com/member.php...o&userid=36200 View this thread: http://www.excelforum.com/showthread...hreadid=559865 |
Can you automate numbers in Excel?
take a look at See http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Heather Stokes" <Heather.Stokes.2aqd4n_1152536366.6176@excelforu m-nospam.com wrote in message news:Heather.Stokes.2aqd4n_1152536366.6176@excelfo rum-nospam.com... I need a number to automatically populate a cell with a unique number each time the worksheet is opened. The number being populated needs to populate in numerical order. For example, I have a worksheet that is being used as a form which requires a unique number to be used as the "ticket number". Each time the form is pulled up and used in Excel as an official "ticket", it needs to have a different number; each subsequent ticket shall follow the ticket number before it. The first ticket number would be 1. Then when the same form was opened up to be used the second time, the ticket number would be 2 and so on. Can such a function be accomplished in Mircrosoft Excel? Thanks in advance. Heather Stokes -- Heather Stokes ------------------------------------------------------------------------ Heather Stokes's Profile: http://www.excelforum.com/member.php...o&userid=36200 View this thread: http://www.excelforum.com/showthread...hreadid=559865 |
Can you automate numbers in Excel?
But this works in one workbook only. How to make it available in all workbooks.
"Bob Phillips" wrote: take a look at See http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Heather Stokes" <Heather.Stokes.2aqd4n_1152536366.6176@excelforu m-nospam.com wrote in message news:Heather.Stokes.2aqd4n_1152536366.6176@excelfo rum-nospam.com... I need a number to automatically populate a cell with a unique number each time the worksheet is opened. The number being populated needs to populate in numerical order. For example, I have a worksheet that is being used as a form which requires a unique number to be used as the "ticket number". Each time the form is pulled up and used in Excel as an official "ticket", it needs to have a different number; each subsequent ticket shall follow the ticket number before it. The first ticket number would be 1. Then when the same form was opened up to be used the second time, the ticket number would be 2 and so on. Can such a function be accomplished in Mircrosoft Excel? Thanks in advance. Heather Stokes -- Heather Stokes ------------------------------------------------------------------------ Heather Stokes's Profile: http://www.excelforum.com/member.php...o&userid=36200 View this thread: http://www.excelforum.com/showthread...hreadid=559865 |
All times are GMT +1. The time now is 04:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com