>>23284501Honestly, this sounds less like a job for Excel than it does for a full programming language unless you simplify it a little.
That said, for the moves and Pokemon, you can probably make use of Veekun's database:
http://veekun.com/dex/downloadsIt is an SQLite database that contains all the Pokemon, their stats, moves, and a whole slew of other information. If you are dead-set with using Excel, you can probably import this database into Access and then use Excel Macros to pull random rows from certain tables (Like the Pokemon Table) and generate random stats at the click of a button after populating adjacent cells with things like a list of possible Pokemon for a particular area and level ranges. (You could use this to calculate stats:
http://bulbapedia.bulbagarden.net/wiki/Experience)
Alternatively, are you familiar with any programming languages?
