How to shuffle all data in table

Hi Excel Gurus -

Need some help trying to shuffle all the data in the table I provided. I attempted to use the "=rand()" function but I did not like it. In the example, there the data is in B2:B4, C2:C4, and D2:D4. I want to shuffle all the date but keep the data in the same column. Hope I explained this well...please help, thanks!

Use the RAND function as indicated on Sheet 1

Thank you...but I already tried that function as stated in my original post. Reason I don't like it is because it changes the titles in column A

Here's a VBA method of accomplishing the goal:

Please Login or Register  to view this content.

Man, thank you! You are GOOD!!!!!

If this solves your question, please mark the thread as solved.

Your welcome.

Have a Merry Christmas.

Im having trouble getting that "Random" button...you got a youtube link you can provide?

Originally Posted by Logit

Don't understand what you are asking.

No YouTube ... sorry

Apologies for my lack of excel knowledge. I was able to load the VBA code but how do I get that "Randomize" but you input on the last example?

I'm using Excel 2007 so I hope your version looks the same.

First, make certain the code is entered into the module.

Click on DEVELOPER tab up top.

Click on CONTROLS / INSERT

Select BUTTON, top left corner (click on it).

Move mouse to clear area on sheet, click again. Button should now appear on sheet.

If you already have the code entered into the module, when the button appears, another menu box will appear. Click the macro name (Randomize) in the middle of the menu box (Listbox) then click OK.

Now, highlight at least 1 Col and 2 Rows, then click the button.