Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Metric
 
Posts: n/a
Default 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   Report Post  
Ron de Bruin
 
Posts: n/a
Default

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   Report Post  
Jason Morin
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
assign auto number and auto date Krit Kasem Excel Discussion (Misc queries) 2 January 14th 05 03:55 AM
Excel 2000 - How to create an auto search echo7 Excel Discussion (Misc queries) 1 December 17th 04 05:32 PM
Use Julian Date To Create Serial Number antho10359 Excel Discussion (Misc queries) 4 December 9th 04 02:50 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM


All times are GMT +1. The time now is 11:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"