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?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How to automatically continue a series of numbers a next worksheet?
Similar threads
- Solved
- Question
