Sorting Across Multiple Worksheets

[Saighead]

Hi,

I'm working with a largish dataset (3M+ rows). As there's a 1M+ limitation built into Excel, this dataset is split across four worksheets. Is there a way to make Excel treat them as one? For instance, when sorting. The entire dataset should be treated as a single Worksheet, so that rows that appear on WSheet4 but alphabetically belong on WSheet1 should be moved there, while the bottom rows of WSheet1 which now exceed the max length should move to WSheet2, and so on.

Is this doable?

[PeteABC123]

All that data in Excel would likely bog down Excel and your machine to the point of unusability. Best bet is to store your data in Access or similar database. Use Excel to perform queries and summon records as needed.

Pete