Yet another Q

  • Thread starter Thread starter Steven Hook
  • Start date Start date
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
 
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
 
Hi,
All 16 sheets have all 65536 rows filled, (it's a 500MB file) so they have
to be on seperate sheets.
Steven
 
Steven,

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

HTH,
Bernie
MS Excel MVP
 
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...
 
Back
Top