ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   lots of data (https://www.excelbanter.com/excel-discussion-misc-queries/26064-lots-data.html)

lwm11

lots of data
 
Is there any way that when you export so much data that once it fills up all
the 65K plus sections on sheet one, it will automatically flow to sheet two
and so on?


Gary Brown

I created a stand-alone workbook that will do this for text-delimited files.
I haven't gotten around to csv files yet. It's a work in progress but if you
are interested let me know at...
--
Gary Brown



"lwm11" wrote:

Is there any way that when you export so much data that once it fills up all
the 65K plus sections on sheet one, it will automatically flow to sheet two
and so on?


Gary Brown

I mean 'Tab-Delimited'. :O
--
Gary Brown



"Gary Brown" wrote:

I created a stand-alone workbook that will do this for text-delimited files.
I haven't gotten around to csv files yet. It's a work in progress but if you
are interested let me know at...
--
Gary Brown



"lwm11" wrote:

Is there any way that when you export so much data that once it fills up all
the 65K plus sections on sheet one, it will automatically flow to sheet two
and so on?



All times are GMT +1. The time now is 11:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com