Generate number NOT using a form
Hi,
I've searched hi an low on this site and others, and the nearest match was a question from Galaxykid in November. I'm running Office 2000 and have used the Template Wizaed to create a template that is used as a form to input data into another spreadsheet. I would like one field on the template (which appears as a spreadsheet NOT an Excel Form) to generate sequential numbers for each new record that is entered and saved using my template. I know it can't be that hard but I've been trying to figure this out for two days! Help!!!!! Thanks in advance. Davis |
Try looking at the following link
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- Regards Roger Govier "DavisC" wrote in message ... Hi, I've searched hi an low on this site and others, and the nearest match was a question from Galaxykid in November. I'm running Office 2000 and have used the Template Wizaed to create a template that is used as a form to input data into another spreadsheet. I would like one field on the template (which appears as a spreadsheet NOT an Excel Form) to generate sequential numbers for each new record that is entered and saved using my template. I know it can't be that hard but I've been trying to figure this out for two days! Help!!!!! Thanks in advance. Davis |
Awesome!! Thanks very much, Roger, I really appreciate it.
"Roger Govier" wrote: Try looking at the following link http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- Regards Roger Govier "DavisC" wrote in message ... Hi, I've searched hi an low on this site and others, and the nearest match was a question from Galaxykid in November. I'm running Office 2000 and have used the Template Wizaed to create a template that is used as a form to input data into another spreadsheet. I would like one field on the template (which appears as a spreadsheet NOT an Excel Form) to generate sequential numbers for each new record that is entered and saved using my template. I know it can't be that hard but I've been trying to figure this out for two days! Help!!!!! Thanks in advance. Davis |
All times are GMT +1. The time now is 02:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com