Instigator
New member
- Joined
- Aug 9, 2016
- Messages
- 41
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 2016
Col1 | Col2 | Col3 | Col4 | Col5 | Col6 | Col7 | Col8 | ...Col(nth) | |
Row1 | itemA | itemE | itemD | itemC | itemB | itemA | itemE | itemD | itemC |
Row2 | itemB | itemA | itemE | itemD | itemC | itemB | itemA | itemE | itemD |
Row3 | itemC | itemB | itemA | itemE | itemD | itemC | itemB | itemA | itemE |
Row4 | itemD | itemC | itemB | itemA | itemE | itemD | itemC | itemB | itemA |
Row5 | textR | textV | textT | textR | textV | textT | textR | textV | textT |
Row6 | textS | textW | textU | textS | textW | textU | textS | textW | textU |
Row7 | textT | textR | textV | textT | textR | textV | textT | textR | textV |
Row8 | textU | textS | textW | textU | textS | textW | textU | textS | textW |
Dyanmic Named Range 1 | Dynamic Named Range 2 |
itemA | textR |
itemB | textS |
itemC | textT |
itemD | textU |
itemE | textV |
item(nth) | textW |
text(nth) |
Okay, so what I am trying to do is create two dynamic ranges where the quantity (#) of values in each column is arbitrary. Then, on a second sheet, paste these ranges in the format that I laid out in the top table so that the table is filled with a repetition of values in the area specified based on the named ranges. The process would look something like this: Range 1 fills (in a looping fashion) Col1 Row1 through Row4, then fills Col2 Row1 through Row4, then fills Col3 Row1 through Row4...etc. In this way, the total area (Col1 Row1 to Col(nth) Row4) repeats the list values from Range 1, despite the quantity of values in the range. A similar process would be completed for Range 2 on Rows 5 through 8.
If any anything in my explanation in my problem was unclear, please let me know and I will try my best to provide further explanation.
Thank you in advance for any assistance that anyone has to offer as to how the most sensible method to accomplish this task would be.
Last edited: