Above 65536 Data to be paste

[amksingh]

Hi All,
I copieed data from multiple sheets and start to pasting in a sheets.. but problem is this data is above 65536 and cant paste in one sheet..
how can I create automatic new sheets when data reach 65536 and rest data paste in that sheets by macro...

pls help me

[Kenneth Hobs]

Welcome to the forum! Apparently, you are using a version prior to 2007.

What are you copying from?

If you are importing text files, here is a method. http://www.cpearson.com/excel/importbigfiles.aspx

[frank_m]

The code at the link below is designed to combine multiple worksheets with identical sheet structure, from multiple workbooks, into one workbook, as many sheets as needed.

If I understand you correctly all of your data comes from sheets within one workbook only, but perhaps you can remove the filename search and loop part of it, so that it works on a single workbook.
http://vbaexpress.com/kb/getarticle.php?kb_id=773