Forum Discussion

Bookman's avatar
Bookman
Copper Contributor
Nov 22, 2018

Need help - complex formula for labels

Hello everyone,

 

Thank you for taking the time to read this.

 

I have to update the following table 200 times with the following rules -

FW is constant.

First number (country) range is 1-61

Second number (state) range is 1-10

Third number (city) range is 1-6

Ex. AB 1-1-1 to AB 61-10-6

And I need 9 of each.

 

They have to fit into this table grid (27x7):

FW 1-1-1FW 1-1-4FW 1-2-1FW 1-2-4FW 1-3-1FW 1-3-4FW 1-4-1
FW 1-1-1FW 1-1-4FW 1-2-1FW 1-2-4FW 1-3-1FW 1-3-4FW 1-4-1
FW 1-1-1FW 1-1-4FW 1-2-1FW 1-2-4FW 1-3-1FW 1-3-4FW 1-4-1
FW 1-1-1FW 1-1-4FW 1-2-1FW 1-2-4FW 1-3-1FW 1-3-4FW 1-4-1
FW 1-1-1FW 1-1-4FW 1-2-1FW 1-2-4FW 1-3-1FW 1-3-4FW 1-4-1
FW 1-1-1FW 1-1-4FW 1-2-1FW 1-2-4FW 1-3-1FW 1-3-4FW 1-4-1
FW 1-1-1FW 1-1-4FW 1-2-1FW 1-2-4FW 1-3-1FW 1-3-4FW 1-4-1
FW 1-1-1FW 1-1-4FW 1-2-1FW 1-2-4FW 1-3-1FW 1-3-4FW 1-4-1
FW 1-1-1FW 1-1-4FW 1-2-1FW 1-2-4FW 1-3-1FW 1-3-4FW 1-4-1
FW 1-1-2FW 1-1-5FW 1-2-2FW 1-2-5FW 1-3-2FW 1-3-5FW 1-4-2
FW 1-1-2FW 1-1-5FW 1-2-2FW 1-2-5FW 1-3-2FW 1-3-5FW 1-4-2
FW 1-1-2FW 1-1-5FW 1-2-2FW 1-2-5FW 1-3-2FW 1-3-5FW 1-4-2
FW 1-1-2FW 1-1-5FW 1-2-2FW 1-2-5FW 1-3-2FW 1-3-5FW 1-4-2
FW 1-1-2FW 1-1-5FW 1-2-2FW 1-2-5FW 1-3-2FW 1-3-5FW 1-4-2
FW 1-1-2FW 1-1-5FW 1-2-2FW 1-2-5FW 1-3-2FW 1-3-5FW 1-4-2
FW 1-1-2FW 1-1-5FW 1-2-2FW 1-2-5FW 1-3-2FW 1-3-5FW 1-4-2
FW 1-1-2FW 1-1-5FW 1-2-2FW 1-2-5FW 1-3-2FW 1-3-5FW 1-4-2
FW 1-1-2FW 1-1-5FW 1-2-2FW 1-2-5FW 1-3-2FW 1-3-5FW 1-4-2
FW 1-1-3FW 1-1-6FW 1-2-3FW 1-2-6FW 1-3-3FW 1-3-6FW 1-4-3
FW 1-1-3FW 1-1-6FW 1-2-3FW 1-2-6FW 1-3-3FW 1-3-6FW 1-4-3
FW 1-1-3FW 1-1-6FW 1-2-3FW 1-2-6FW 1-3-3FW 1-3-6FW 1-4-3
FW 1-1-3FW 1-1-6FW 1-2-3FW 1-2-6FW 1-3-3FW 1-3-6FW 1-4-3
FW 1-1-3FW 1-1-6FW 1-2-3FW 1-2-6FW 1-3-3FW 1-3-6FW 1-4-3
FW 1-1-3FW 1-1-6FW 1-2-3FW 1-2-6FW 1-3-3FW 1-3-6FW 1-4-3
FW 1-1-3FW 1-1-6FW 1-2-3FW 1-2-6FW 1-3-3FW 1-3-6FW 1-4-3
FW 1-1-3FW 1-1-6FW 1-2-3FW 1-2-6FW 1-3-3FW 1-3-6FW 1-4-3
FW 1-1-3FW 1-1-6FW 1-2-3FW 1-2-6FW 1-3-3FW 1-3-6FW 1-4-3

 

Is there a macro I can set up or calculation that can allow me to keep updating the above table automatically?

Note that once it reaches 1-10-6 the next number is 2-1-1.

 

No RepliesBe the first to reply

Resources