Generating a random word from a list that is dependant on previous selections

[DariaLoveborn]

Hello,

This is the first time I've ever posted on a forum but I've scoured the internet for a solution to no avail.

I am creating a character generator and require it to randomly select a skill from a list that is dependant on the character level and also previous skills selected.

(Ignore the data in column O for now, it was a test) I want it to randomly select 2 skills from the LVL1 section of column M. Then, In column P I want it to randomly select 2 skills from the LVL1 and LVL2 sections of M without returning any of the selections from previous results.

I'm semi familiar with VBA and with clear instruction I can pretty much put anything together. I just can't figure this out.

Please help.

Thanks

Jen

 

[DariaLoveborn]

If it's easier I can send you the sheet to look at

 

[Snakehips]

Cannot send file via forum. Post a link to it on Dropbox or the like?

 

[DariaLoveborn]

Yeah that I can do. Or happy to email it over. I have a bit more information to add into the final few lists.