Thanks Dave, At the moment, the sheet doesn't use a macro - it is done with a formula that looks at and selects from a column within the work book.
S On Oct 28, 3:55 am, Dave Bonallack <davebonall...@hotmail.com> wrote: > Hi Simon, > > If you post your current code, someone can probably suggest the necessary > mods. > > Regards - Dave > > > > > > > Date: Tue, 27 Oct 2009 08:12:32 -0700 > > Subject: $$Excel-Macros$$ New user VBA to help random sheet > > From: simongall...@googlemail.com > > To: excel-macros@googlegroups.com > > > Hello, > > > I am a teacher and use an excel document that makes tests drawn > > randomly from a bank of questions - there are a few list of questions > > and the test has q1 picking a random q from bank 1 etc. After a few > > questions it goes back and picks again from the first bank... The > > banks of questions are very long and so the chances of getting > > repeated questions are slim. > > > However - I now need to work out a way of not picking the same > > question twice - I'm about to make new tests that will necessarily > > select from a smaller list of questions. > > > Is there a way of using VBA to make this happen? If so could someone > > point me in the right direction? Any help much appreciated. > > > Simon > > _________________________________________________________________ > Use Messenger in your Hotmail inbox Find out how > herehttp://windowslive.ninemsn.com.au/article.aspx?id=823454 --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
