What I want to do is this: I have a many cells scattered throughout many worksheets. I want to take these cells and put them in one long list. But I want the cells to be in a random order. I could with some work just copy all these cells onto the list, but I want to make it in a random order. I want it to work like sort ascending button, except instead of creating order, making it disorganized.
I may need to add more info to describe what I want to do.