Automatically use next number on a template
I have a template, with data tracking. Currently when somebody uses the
template they type the next consecutive number in one of the cells. I want this to be automated and chosen from a list of numbers, choosing the next avaialable? Cheers -- Nenagh |
Automatically use next number on a template
Hi
Take a look at the methods used by JE McGimpsey http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- Regards Roger Govier "Nenagh" wrote in message ... I have a template, with data tracking. Currently when somebody uses the template they type the next consecutive number in one of the cells. I want this to be automated and chosen from a list of numbers, choosing the next avaialable? Cheers -- Nenagh |
All times are GMT +1. The time now is 04:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com