Forum Discussion
Bookman
Nov 22, 2018Copper Contributor
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-1 | FW 1-1-4 | FW 1-2-1 | FW 1-2-4 | FW 1-3-1 | FW 1-3-4 | FW 1-4-1 |
FW 1-1-1 | FW 1-1-4 | FW 1-2-1 | FW 1-2-4 | FW 1-3-1 | FW 1-3-4 | FW 1-4-1 |
FW 1-1-1 | FW 1-1-4 | FW 1-2-1 | FW 1-2-4 | FW 1-3-1 | FW 1-3-4 | FW 1-4-1 |
FW 1-1-1 | FW 1-1-4 | FW 1-2-1 | FW 1-2-4 | FW 1-3-1 | FW 1-3-4 | FW 1-4-1 |
FW 1-1-1 | FW 1-1-4 | FW 1-2-1 | FW 1-2-4 | FW 1-3-1 | FW 1-3-4 | FW 1-4-1 |
FW 1-1-1 | FW 1-1-4 | FW 1-2-1 | FW 1-2-4 | FW 1-3-1 | FW 1-3-4 | FW 1-4-1 |
FW 1-1-1 | FW 1-1-4 | FW 1-2-1 | FW 1-2-4 | FW 1-3-1 | FW 1-3-4 | FW 1-4-1 |
FW 1-1-1 | FW 1-1-4 | FW 1-2-1 | FW 1-2-4 | FW 1-3-1 | FW 1-3-4 | FW 1-4-1 |
FW 1-1-1 | FW 1-1-4 | FW 1-2-1 | FW 1-2-4 | FW 1-3-1 | FW 1-3-4 | FW 1-4-1 |
FW 1-1-2 | FW 1-1-5 | FW 1-2-2 | FW 1-2-5 | FW 1-3-2 | FW 1-3-5 | FW 1-4-2 |
FW 1-1-2 | FW 1-1-5 | FW 1-2-2 | FW 1-2-5 | FW 1-3-2 | FW 1-3-5 | FW 1-4-2 |
FW 1-1-2 | FW 1-1-5 | FW 1-2-2 | FW 1-2-5 | FW 1-3-2 | FW 1-3-5 | FW 1-4-2 |
FW 1-1-2 | FW 1-1-5 | FW 1-2-2 | FW 1-2-5 | FW 1-3-2 | FW 1-3-5 | FW 1-4-2 |
FW 1-1-2 | FW 1-1-5 | FW 1-2-2 | FW 1-2-5 | FW 1-3-2 | FW 1-3-5 | FW 1-4-2 |
FW 1-1-2 | FW 1-1-5 | FW 1-2-2 | FW 1-2-5 | FW 1-3-2 | FW 1-3-5 | FW 1-4-2 |
FW 1-1-2 | FW 1-1-5 | FW 1-2-2 | FW 1-2-5 | FW 1-3-2 | FW 1-3-5 | FW 1-4-2 |
FW 1-1-2 | FW 1-1-5 | FW 1-2-2 | FW 1-2-5 | FW 1-3-2 | FW 1-3-5 | FW 1-4-2 |
FW 1-1-2 | FW 1-1-5 | FW 1-2-2 | FW 1-2-5 | FW 1-3-2 | FW 1-3-5 | FW 1-4-2 |
FW 1-1-3 | FW 1-1-6 | FW 1-2-3 | FW 1-2-6 | FW 1-3-3 | FW 1-3-6 | FW 1-4-3 |
FW 1-1-3 | FW 1-1-6 | FW 1-2-3 | FW 1-2-6 | FW 1-3-3 | FW 1-3-6 | FW 1-4-3 |
FW 1-1-3 | FW 1-1-6 | FW 1-2-3 | FW 1-2-6 | FW 1-3-3 | FW 1-3-6 | FW 1-4-3 |
FW 1-1-3 | FW 1-1-6 | FW 1-2-3 | FW 1-2-6 | FW 1-3-3 | FW 1-3-6 | FW 1-4-3 |
FW 1-1-3 | FW 1-1-6 | FW 1-2-3 | FW 1-2-6 | FW 1-3-3 | FW 1-3-6 | FW 1-4-3 |
FW 1-1-3 | FW 1-1-6 | FW 1-2-3 | FW 1-2-6 | FW 1-3-3 | FW 1-3-6 | FW 1-4-3 |
FW 1-1-3 | FW 1-1-6 | FW 1-2-3 | FW 1-2-6 | FW 1-3-3 | FW 1-3-6 | FW 1-4-3 |
FW 1-1-3 | FW 1-1-6 | FW 1-2-3 | FW 1-2-6 | FW 1-3-3 | FW 1-3-6 | FW 1-4-3 |
FW 1-1-3 | FW 1-1-6 | FW 1-2-3 | FW 1-2-6 | FW 1-3-3 | FW 1-3-6 | FW 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