Sequential numbers and letters across cells

I'm trying to write a script that will do the following:

It clears the content of each cell in a column and sets the value to A01, A02, A03... all the way to A12. When it reaches A12 it switches to B01 for the next cell in the column and continues this pattern until it reaches G12.

Example for clarity. Imagining each line is a cell:
A01
A02
A03
...
A12
B01
B02
B03
...
G12

I know this should be pretty easy but I think I'm struggling with the logic. If anyone could give me a shove in the write direction, that would help my learning of VBA tremendously. Thank you so much for you time.

I can do it with two columns but I'm struggling to get a one column solution.

A2: =MOD(ROW()-2,12)+1
B2: =CHAR(COUNTIF($A$2:$A2,1)+64)&TEXT(A2,"00")

Both copied down.

Are you using Excel 365? If so, please update your profile.

Anyway something to be going on with.

With Vba.

Please Login or Register  to view this content.

Or:

Please Login or Register  to view this content.