There is, yes, but might some of the data on say sheet 2 go before the data
on sheet 1? It would seem so, if that is the case it will be best to put it
in access first or to read it all into an array and sort that way.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


" wrote:

I have a very large data set in Excel that can't be placed on one page
(over 1.2 mil rows) and therefore it's been organized on multiple
tabs.

Is there a way to sort this data by date (which is a column set) in
each sheet/tab without doing it manually for each tab?