Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Create an Auto Number
My company has a service log (Excel Spreadsheet) they started 3 years
ago...each entry was given a manual number (column A)...over time people have just generated that number manually...sometimes they can't count and the next number is 1 off. I'm trying to determine if there is an easier way to auto generate the next number in the list. For example we are at 7000; I want the next row down to generate 7001. How can I do this??? |
#2
|
|||
|
|||
Hi Metric
If you start in row 1 you can use thsi formula and copy it down =ROW() If you start in row 6 then you can use this =ROW()-5 -- Regards Ron de Bruin http://www.rondebruin.nl "Metric" wrote in message ... My company has a service log (Excel Spreadsheet) they started 3 years ago...each entry was given a manual number (column A)...over time people have just generated that number manually...sometimes they can't count and the next number is 1 off. I'm trying to determine if there is an easier way to auto generate the next number in the list. For example we are at 7000; I want the next row down to generate 7001. How can I do this??? |
#3
|
|||
|
|||
What triggers the invoice # to be created? If the user
enters a value in column B, this will trigger the next sequential invoice # in col. A: Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Count 1 Then Exit Sub If Not Intersect(Target, Range("B:B")) Is Nothing Then With Target .Offset(0, -1).Value = .Offset(-1, -1).Value + 1 End With End If End Sub --- To load this, right-click the worksheet tab, View Code, and paste this in. HTH Jason Atlanta, GA -----Original Message----- My company has a service log (Excel Spreadsheet) they started 3 years ago...each entry was given a manual number (column A)...over time people have just generated that number manually...sometimes they can't count and the next number is 1 off. I'm trying to determine if there is an easier way to auto generate the next number in the list. For example we are at 7000; I want the next row down to generate 7001. How can I do this??? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
assign auto number and auto date | Excel Discussion (Misc queries) | |||
Excel 2000 - How to create an auto search | Excel Discussion (Misc queries) | |||
Use Julian Date To Create Serial Number | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |