26,403 views 249 on YTPak
61 4

Published on 16 Oct 2013 | over 3 years ago

Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday.
For details you can visit our website:
Josh wants to know how to create a test paper from a question bank using Excel VBA. He wants a random test paper to be created with unique questions. We use the random function to generate a number. We also ensure that no duplicate number is used by generating another number if the same number is generated by Excel using the countif function.This number is then used to get a question from Sheet2 into Sheet1. In this manner we ensure no duplicates in our question test paper and a truly randomly generated question paper.
We also learn how to write a lot of interesting and useful VBA code.
Details with complete VBA code: www.familycomputerclub.com/Generate-Test-Paper-from-Question-Bank-Using-Excel-VBA.html

Loading related videos...