Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I concatenate information in Excel and keep the number form | Excel Worksheet Functions | |||
In Excel how can a number automatically display in text form | Excel Worksheet Functions | |||
How do I set up a field in an Excel form to number it incremental. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
generate serial number | Excel Worksheet Functions |