Forum Discussion
Autofill numeration in row until last empty cell
Hi, How can I create macro which can autofill numeration in row. It have to end this macro at the end of this table. I was trying to make it in this way: It worked perfect, but in empty sheet. I...
I would like to update numeration to the end until something is next to the numeration column.
When inserting a row, you just need to drag down the formula. Click the cell and right until cross appears and just pull down.
With VBA code, in your case, a line of code would also have to be inserted for each table and if the lines change, then the code would have to change accordingly. I think this would be even more cumbersome for you.