DariaLoveborn
New Member
- Joined
- Apr 17, 2020
- Messages
- 13
- Office Version
- 365
- Platform
- Windows
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
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