Question: Create a nested-loop program (you can use any type of loop you would like). This nested loop should take the names input (below) and print

Create a nested-loop program (you can use any type of loop you would like). This nested loop should take the names input (below) and print out every possible combination of first and middle names. These input names will need to appear in your workbook somewhere. (Make sure you type the list of first and middle names in your workbook) Then, output every possible combination of first and middle names somewhere in the worksheet. Your program should work correctly with more or less first names and middle names. Below is an example input and output. To save space, only the names associated with the first two first names are shown in the example output.

To explain some more, take 'Penelope' from the first name list and combine it with all middle names in the range and continue till there are no more names in the range of first names.

First names Middle names
Penelope Jill
Gwyneth Diane
Alice Heidi
Anna Lilly
Victoria

Please Post a Screenshot of the VBA code

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!