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
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:
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?
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!