Hi....
Got a random question, like everyone else
I'm trying to concatenate 3 dynamically named ranges and output them on the same worksheet.
I have data in Column A which is named Mode, I have data in Column B named Area, and data in Column C which is named Test.
I want to concatenate all 3 and output all possible combinations.
For example:
A B C
SP San F Physics
Coop Detroit Scoring
MP Asia SFX
These are just examples.....I'm looking for a way to create the output:
SP - San F - Physics
SP - San F - Scoring
SP - San F - SFX
SP - Detroit - Physics
SP - Detroit - Scoring
SP - Detroit - SFX
SP - Asia - Physics
SP - Asia - Scoring
SP - Asia - SFX
Coop - San F - Physics
.....
and on and on, you get the idea. In this instance, I would be looking for a list of 27 combinations, I believe. However, each of those ranges are dynamic, and I would like to be able to add to that list without being required to constantly change code.
Many thanks,
Brian
Got a random question, like everyone else
I'm trying to concatenate 3 dynamically named ranges and output them on the same worksheet.
I have data in Column A which is named Mode, I have data in Column B named Area, and data in Column C which is named Test.
I want to concatenate all 3 and output all possible combinations.
For example:
A B C
SP San F Physics
Coop Detroit Scoring
MP Asia SFX
These are just examples.....I'm looking for a way to create the output:
SP - San F - Physics
SP - San F - Scoring
SP - San F - SFX
SP - Detroit - Physics
SP - Detroit - Scoring
SP - Detroit - SFX
SP - Asia - Physics
SP - Asia - Scoring
SP - Asia - SFX
Coop - San F - Physics
.....
and on and on, you get the idea. In this instance, I would be looking for a list of 27 combinations, I believe. However, each of those ranges are dynamic, and I would like to be able to add to that list without being required to constantly change code.
Many thanks,
Brian