Looks like a tough call ..
(Your original posting showing the set-up is indecipherable)

Can you upload your sample file using a free filehost,
then post a link to it here?

For example, you could use this free filehost to upload:
http://www.freefilehosting.net/

Copy the "direct link" which is generated after you upload,
then paste it here

(Desensitize your sample as appropriate)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 16,400, Files: 356, Subscribers: 53
xdemechanik
---
"Ryan" wrote in message
...
I want the same configuration of the grid in sheet 2 over and over. I want
the source data from sheet 1 to be reconfigured to be B1 then to the right
A1
and below that C1. I need to jumble up the source data and reproduce the
jumbled configuration multiple times.