good morning everyone!
the problem: auto generate a numerical sequence followed by /+ current year;
and sequentially in the table sheet (in my case there are one for each month of the year)and the numerical sequence must continue sequentially regardless of the sheet.
ex: january -01/2021, 02/2021, .....
february -03/2021, 04/2021, .....
and if i go back to january i can put 05/2021.
what have i managed to do:
I've already managed to do the sequence, automatic filling between the tables, almost the whole problem I've already solved
what i couldn't do:
delete a row, if I delete any row from the table, all subsequent numbers change too, regressing to the number in the same amount as they are deleted, another problem I have is that once I start for example the February sheet, if I go back to include something in January for example all subsequent lines will be added by the same amount.
the problem: auto generate a numerical sequence followed by /+ current year;
and sequentially in the table sheet (in my case there are one for each month of the year)and the numerical sequence must continue sequentially regardless of the sheet.
ex: january -01/2021, 02/2021, .....
february -03/2021, 04/2021, .....
and if i go back to january i can put 05/2021.
what have i managed to do:
I've already managed to do the sequence, automatic filling between the tables, almost the whole problem I've already solved
what i couldn't do:
delete a row, if I delete any row from the table, all subsequent numbers change too, regressing to the number in the same amount as they are deleted, another problem I have is that once I start for example the February sheet, if I go back to include something in January for example all subsequent lines will be added by the same amount.