Hi, I am not sure if this is possible or if I need a macro. I am trying to start a cell at number '500' and start until '600' so an invoice number (for example) start from 500, then 501, then 502, then 503.. etc.. and once it reaches 600, it will jump back to 500. So lets say, cell A1, has 500, and changes to 501, each time an invoice , and it will loop back to 500 once 600 has been reach, so the range of numbers will always be in between 500 to 600. I wonder if this would be possible in a formula or would I need a macro. (I am doing this as a count)
Bookmarks