Hi,

I do various bits of modelling in Excel usually using multiple Data Tables of 10,000 rows in a single worksheet (I like to get fairly stable numbers ). Basically is there a quick way or utility or workaround out there (or even a macro) for setting up data tables in a more efficient manner?

Basically I sort out my first column of 10,000 numbers (1-10,000) for my first data table, copying that column through for however many data tables I have and then I just treat each data table individually and do them as you normally would (it's just with 10,000 lines it seems to take an age ).

I just wondered if anyone had any ideas or workarounds that could speed this up? I've tried reducing the view size, to fit more rows on the screen but then it sometimes becomes more awkward to pick the right cell accurately etc.

Thanks in advance for any suggestions,