Walesm3011
New Member
- Joined
- Sep 11, 2020
- Messages
- 2
- Office Version
- 2016
- Platform
- Windows
Digit 1 | Digit 2 | Digit 3 | Digit 4 | Digit 5 | Digit 6 | Digit 7 | Digit 8 |
C | 1 | 1 | 1 | 1 | 0 | 1 | 1 |
C | 1 | 1 | 2 | 2 | 0 | 2 | 2 |
C | 1 | 1 | 3 | 3 | 0 | 3 | 3 |
C | 1 | 1 | 4 | 4 | 0 | 4 | 4 |
C | 1 | 1 | 5 | 5 | 0 | 5 | 5 |
C | 1 | 1 | 6 | 6 | 0 | 6 | 6 |
C | 1 | 1 | 7 | 0 | 7 | ||
C | 1 | 1 | 8 | 0 | 8 | ||
C | 1 | 1 | 9 | 0 | 9 | ||
C | 1 | 1 | 10 | 0 | |||
C | 1 | 1 | 11 | 0 | |||
C | 1 | 1 | 12 | 0 | |||
C | 1 | 1 | 13 | 0 |
Hi all,
I am looking for a Excel VBA solution for all possible outcomes of a concatenate for the above 8 columns of data with the logic as follows Digit 1. Digit 2. Digit 3 . Digit 4 through to digit 8 each digit should be separated by a .
In the above data
Digit 1 will always = C,
Digit 2 = 1,
Digit 3 = 1,
Digit 4 could anything from 1 to 13,
Digit 5 could could anything from 1 to 6,
Digit 6 will always be 0,
Digit 7 could be anything from 1 to 9,
Digit 8 could be anything from 1 to 6
eg C.1.1.2.3.0.2.6
Any help would be greatly appreciated