Is this possible?

[zendo]

Hello I was wondering if anybody could help me out here. I have this game where you build spaceship and the standard naming system is pretty boring they just give it number.

I was wondering if it's possible to make a list or lists of names and have excel choose from the lists and create a name sort of like this.......

List 1
Fire
Snow
Hammer
Death

List 2
Bird
Hawk
Lizzard
Claw

So it would come up with Fire Claw, Snow Bird something like that.

I don't use excel that much but my wife who does says that it is possible she just dosen't know how to do it.

Any help would be greatly appreciated!

Thank You!

[VBA Noob]

Hi,

Say List 1 in Col A and List 2 in Col B try

Change Range to your range. Press F9 to generate a new name

=INDEX(A2:A5,INT(RAND()*COUNTA(A2:A5))+1)&" "&INDEX(B2:B5,INT(RAND()*COUNTA(A2:A5))+1)


VBA Noob