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?
Bookmarks