Sort rows across multiple worksheets - Excel 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have downloaded data from our iSeries into Excel so the user can do ad-hoc
analysis. May of these files contain over 100,000 records that are contained
in multiple worksheets within the workbook. I need a way that the user can
specify column sequence that will sort all of the data in the multiple
worksheets.
 
You might find it easier to download the data into, say, MsAccess, sort it
there and then copy the sorted data into Excel for further analysis.

Alternatively, you could use Quattro Pro which has a one million row limit.
 
Thanks - I had considered MSAccess, but then the user also has to be familiar
with that product. I was hoping there was a way to do it and be
self-contained in Excel.
 
You must log in or register to reply here.

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

Sorting complex worksheets 1
Excel formulas pulling from another worksheet changes when sorted 1
Multiple sheet querries 4
Does the order of worksheets matter ? 1
COUNTIF across worksheets 3
Merge and Sort 2 worksheets into 3rd 4
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
move a row of data from one work sheet to another using a formula 1

Back
Top