Automatic numbering?

[jassyphee]

I was wondering how do you set automatic numbering through vba scripting for a column start from A5, for selected worksheets, so that when an entry beside it is made, the item is numbered? The number of entries vary. Thank you

 

[farmerscott]

Jassyphee,

can you give us an example of a sheet and the number you have in them and what numbers you want when an entry is made. Should these numbers be randon, consecutive, from a list somewhere?

thx

FarmerScott

 

[jassyphee]

Currently In column A I have the heading item number, and beside it in column B is the description (for example bonds). There are two things I want to accomplish. 1. I want to have the numbers automatically appear when the adjacent cell is occupied, so I used the formula =IF(B5<>"",COUNTA($B$5:B5) however, if I have a sheet with too many entries, this can be tedious/inefficient. That way I want it to automatically be filled. 2. I also want to figure out how to continue the numbering onto a next worksheet. Say, Sheet1 end item no. is 20, I want the next page to start from 21. which I used this formula =Max('Sheet1'!$A$#:A#). Is there someone to do this on macros? here's how the excel looks like:

Jassyphee,

can you give us an example of a sheet and the number you have in them and what numbers you want when an entry is made. Should these numbers be randon, consecutive, from a list somewhere?

thx

FarmerScott

 

[farmerscott]

Jassyphee,

thanks for the information.

A quick couple of questions-

1. when you put in a new line of data will you always start at Col B or anywhere in the row?
2. what will happen if you put data into sheet2 and you then have to insert a row or two into sheet 1? How/what do you want the item number/s to look like?

thx

FarmerScott

 

[jassyphee]

No problem farmerscott. ; )
1. A new line of data will always start at B and the complete row will be completed.
2. When sheet one's number of line changes, I want sheet 2 to correspond accordingly, therefore, if sheet1 ends up with 22 lines instead of 20 lines, i want sheet2 to start numbering from 23. thanks for the help!