Hi, I've created a database of sorts for trivia.
In one worksheet I've got the questions sorted into categories, questions, answers, difficulty and date last used. So cell B2 =Category, C2=Questions, B2=Answers etc...
Is it possible on a separate worksheet to have a formula or a rule to copy a question of a particular category and difficulty into my question sheet with the rule that the question hasn't been used in the last month? (a formula that I could copy for 20 different questions and just change the variable being the category)
And then an extension of that after i've copied a question from the database to the question sheet, is it possible to copy that question with it's answer to an answer sheet on a new worksheet?
And how can I do all of that?
Bookmarks