Select Random Rows and Display on new sheet

**matt4003** · 03-30-2009, 03:42 PM

Hello Everyone,

I have been searching and finally found something close to what I would like to do prior to asking you all. In post: http://www.excelforum.com/excel-prog...selection.html they did an excellent job selecting the random rows.

I need to take it one step further, I need the selected rows to be displayed on a new sheet. The idea being that I have a quiz with hundreds of questions and I only want a random selection to appear when I execute the macro. I plan on hiding the original questions and only displaying the randomly selected ones.

Thanks for your help in advance!

Here is the original code from the previous post.

Please Login or Register  to view this content.

**rylo** · 03-30-2009, 06:02 PM

Hi

Set up and attach an example file showing where your questions will exist, and where you want the output to be placed.

rylo

**matt4003** · 03-30-2009, 07:40 PM

Hello Rylo! Thank you for your help in advance! I have attached a sample of the worksheet ("quiz") for you to see what I am talking about.

One note, I did try to edit the code and put "rows" in place of "cells", and tried to preselect the area for the random selection to take place. But I don't think my changes worked.

**rylo** · 03-31-2009, 02:25 AM

Hi

How many questions do you want returned? Is it a fixed number, or will it be asked somehow?

rylo

**matt4003** · 03-31-2009, 10:36 AM

Hello Rylo,

It would make the most sense to me to have the number of questions picked be static in the VBA. Hopefully though I will be able to change that value just by changing the single code value.

Let's start with 5 questions.

Regards,
Matt

**shg** · 03-31-2009, 01:18 PM

Here's a start ...

**matt4003** · 03-31-2009, 02:02 PM

Hi Rylo!

Very cleaver and awesome!

One thing that I think will be necessary is to understand how the "student" did, or which questions are right and which are wrong. Perhaps I am missing it, but how (on the quiz page) do I show if the answer is right or wrong? Similar to the original example, is it possible to show immediate feedback after the question has been answered?

Many thanks!
Matt

**shg** · 03-31-2009, 03:08 PM

Good job, Rylo!

**matt4003** · 03-31-2009, 05:13 PM

Hello Shg,

Sorry, I didn't even catch that you wrote the file. You and Rylo are a good team:-)

Any thoughts on the other part of the question? Providing instant feedback to the correctness of the answer?

Many thanks!

Matt

**shg** · 03-31-2009, 05:58 PM

Maybe like this.

My teammate will take over from here ...

**rylo** · 03-31-2009, 06:04 PM

Gees, I seem to have walked into a final, great, working solution here. What more can I say.

rylo

**shg** · 03-31-2009, 06:35 PM

Fixed a bug!

**matt4003** · 03-31-2009, 08:20 PM

This is really great stuff!

It works excellent, for me. I did some quick testing on my co-workers computer and I get an error.

"Compile Error:
Can't find project or library."

Is there something special that I need to do to their excel (their = tried two co-workers, both got the same error)? I do a lot of Macro stuff on my excel so I have many add-ins, though I am not sure exactly what is causing this error.

I have attached a screen shot of the error.

Cheers,
Matt

**shg** · 04-01-2009, 04:52 PM

In the VBE, do Tools > References, and look at the checked items in the list (which are all at the top). One will likely say MISSING. Uncheck it.

**matt4003** · 04-01-2009, 05:00 PM

What I see is attached. I don't see anything that says "Missing". Other thoughts? Perhaps one of the ones I have checked is not necessary.

Regards,
Matt

**shg** · 04-01-2009, 05:21 PM

That's what you see on your computer, or what you see on theirs?

**matt4003** · 04-01-2009, 07:07 PM

Nevermind. I got it to work. Thanks for your hint and suggestion on where to look.

Again, I very much appreciate your help, this has been a fun learning experience.

Cheers,
Matt

**shg** · 04-01-2009, 07:09 PM

You’re welcome. Would you please mark the thread as Solved?

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes

**saravanak** · 07-02-2009, 02:45 AM

This is what exactly i am looking for a training project of mine.

i have a set of 500 questions which i wish to give randomly to the participants of a technical training program.

can some one please, share with me the code.

i dont need answers to pop up. i have a page of 500 rows and 1 random row has to appear on a seperate page. thats all.

can some one please help.

thanks in advance,
sravan

**shg** · 07-02-2009, 02:48 AM

Welcome to the forum.

Please take a few minutes to read the forum rules, and then start your own thread.

**nzconway** · 02-09-2011, 09:29 PM

Originally Posted by shg

Here's a start ...

I would be grateful if you could reattach the solution to this query. I'm trying to do a similar thing i.e select random rows from one worksheet and display them on a different worksheet. Many thanks in advance.

**shg** · 02-09-2011, 09:34 PM

Here you go ...

**faye g** · 02-27-2013, 06:16 AM

This is similar to the one that I'm doing. The only difference is that the source data is filtered and I need to copy random rows from the filtered table and paste to a new worksheet. Can you help me on this?

Thank you so much in advance.

**arlu1201** · 02-27-2013, 06:54 AM

Faye,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.

Select Random Rows and Display on new sheet

LinkBack

Thread Tools

Rate This Thread

Display

Select Random Rows and Display on new sheet

Re: Select Random Rows and Display on new sheet

Re: Select Random Rows and Display on new sheet

Re: Select Random Rows and Display on new sheet

Re: Select Random Rows and Display on new sheet

Re: Select Random Rows and Display on new sheet

Re: Select Random Rows and Display on new sheet

Re: Select Random Rows and Display on new sheet

Re: Select Random Rows and Display on new sheet

Re: Select Random Rows and Display on new sheet

Re: Select Random Rows and Display on new sheet

Re: Select Random Rows and Display on new sheet

Re: Select Random Rows and Display on new sheet

Re: Select Random Rows and Display on new sheet

Re: Select Random Rows and Display on new sheet

Re: Select Random Rows and Display on new sheet

Re: Select Random Rows and Display on new sheet

Re: Select Random Rows and Display on new sheet

Re: Select Random Rows and Display on new sheet

Re: Select Random Rows and Display on new sheet

Re: Select Random Rows and Display on new sheet

Re: Select Random Rows and Display on new sheet

Re: Select Random Rows and Display on new sheet

Re: Select Random Rows and Display on new sheet

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions