I am trying to build a small, simple macro that randomly generates responses into a very specific set of cells when you push a button.
I have two columns separated by 3 categories, with 5 cells representing answers to each category; populated from two different Range lists (ListCurrent, ListFuture).
There are 3 categories that separate 5 rows which are Questions where the random results are "the Answers (Answer1 Answer2).
I've attached a sample for you to see what I'm trying to accomplish. Please add some comments so I know how to scale it.
Thank you in advance,