Combinations Question

[chuckjitsu]

Good morning (or afternoon or evening, depending on where you are!). I searched here, but couldn't seem to find a specific answer to what I'm looking for, so if someone knows of a link and can provide it, that would be great. I'm also good with either a VBA solution or worksheet based solution if somebody can do that relatively quickly/easily.

I have four columns, A-D, and each column can contain a value from 1 to 8, meaning the total number of combinations would be 8^4, or 4096. The combination output would look like the below:

1111
1112
1113
etc., with the last value presumably being
8888

Thanks in advance for any assistance.

 

[Eric W]

Glad we could help! Thanks for the update.