Yet another Q

S

Steven Hook

Hi,
I have a sequence of numbers running through 16 sheets in a workbook and I
need to randomise them, when there's less than 1 sheet it's easy to put
"=Random()" befort the set of data and sort by that, but over several sheets
I don't know what to do!
Thanks
Steven
 
B

Bernie Deitrick

Steven,

You could create a 17th sheet with enough numbers for all 16 sheets, and use
links on those sheets.

HTH,
Bernie
MS Excel MVP
 
S

Steven Hook

Hi,
All 16 sheets have all 65536 rows filled, (it's a 500MB file) so they have
to be on seperate sheets.
Steven
 
B

Bernie Deitrick

Steven,

Then you'll need to use 16 columns on one sheet to host the numbers, and use
links.

HTH,
Bernie
MS Excel MVP
 
S

Steven Hook

Will try!
Thanks
Steven

Bernie Deitrick said:
Steven,

Then you'll need to use 16 columns on one sheet to host the numbers, and use
links.

HTH,
Bernie
MS Excel MVP
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Calling from sheets not yet created 10
Forms collection in vba 14
Sort a "range" of sheets. 1
Numbering of worksheets 2
Excel Formula or equation 3
Another search issue 2
Linking from list 1
MACRO RUN random percentage and copy of column values 1

Top