Hello all!



Can anyone help me and tell how i will get the excel to automatically continue and fulfill mine pattern?

The main idea is that i have to start from 001-01-01

The last value (on the right side) varies from 01 to 03.

Example:After 001-01-03 follows 001-02-01 and after 001-02-03 comes 001-03-01 and 001-03-02....

The second value (in the middle) haves values from 01 to 21. After it reaches 21 the firs number will grow by one and the second value drops to 01.

Example: 001-21-03 after comes 002-01-01 and then 002-01-02....

The first value (left side) can have values to for example 1-100

Example: 100-01-01....100-01-02.

Any ideas?
p.s i have excel 2016