make invoice number linked with year access

[ahmedmob]

hi i want to make invoice number linked with year
the number will be in cell and the year in another cell
for example 1/2021 , 2/2021 by Dmax
but the idea i want to recount from beginning when the year ends
so if we reach 160/2021and we become in 2022 it start from beginning 1/2022

[NeoPa]

Hi Ahmed.

This question has been covered a few times on here so have a look at Item Numbering Within a Group & let us know how that works for you.

Please remember that simply saying it doesn't work is as much use as a chocolate teapot. In that scenario we will need help to understand exactly what it is that you don't understand.