create a series of cell values from the concateneation of 2 lists based on a condition

Afternoon all,
I am a complete newbie with excel and vba, and I am struggling with a requirement:

I have a sheet with a series of 6 URL base strings (protocol / host name / port etc) 4 of which are "business" related and 2 of which are "admin" related. I have a separate series of URL endings, again some of which are "admin" and some are "business".

So in the example shown in the picture below cells B1:B4 are the "business" url bases
and cells B5:B6 are the admin url bases
Then cells A9:A21 are the url endings for business URLs and cells A22:A25 are admin url endings

I need to create a list of cells in sheet2: each cell should contain the concatenation of one of the url bases and a url ending, such that I get a complete list of all combinations of url base and url ending. Admin URL bases should only be concatenated with admin url endings and "business" url bases should only be concatenated with "business" url endings.

The idea being that I can generate a list of URLs to test for each new environment that gets built.....



urltestlist.jpg

Any help will be gratefully received....

Cheers!
Dave

Apologies, still finding my way about the forum.,

URLTestingList.xls

Here is a sample of the format of the reference data I have and on sheet 2 the way I want it to come out.

Hope that helps explain what I want.

Cheers!

OK, that works perfectly - it will just take me a while to work out how it does it ;0)

Thanks very much. Apparently I cant give you any more reputation yet, but you deserve it...


Cheers!
Dave