Attached is a sample file, I see Juan has laid the roadwork down though. This is utilizing that exact technique actually..

Keep in mind, in this example, you'll get one sort. There's some other randomize code (don't remember where I got it, probably MrExcel) as it's not all needed with the sort. If desired to just randomize (not sort in a specified order) delete the 'customorder..' line from the code.