[wizbrown]

Greetings everyone,

I'm very new to macros in Excel 2007, although I have found codes that work for my purpose so far.This is for a game idea a friend and I came up with. We have 108 character slots; some of which have already exist, but not all. The characters are identified by three traits: number, name and ability. I have a worksheet with the data for the existing characters. For the ones that don't exist, I want them to be randomly generated using a pool of names and traits that my friend and I have compiled. Here's an example of what I'm trying to say:

#1. Tinker -- Wrench
#3. Soldier -- Firearm
#4. Spy -- Knife

How do I copy a list like that above from one worksheet to another, while randomly generating a new character (name and trait) in slot #2?

Thanks in advance!