View Full Version : Above 65536 Data to be paste

02-16-2012, 05:09 AM
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
02-16-2012, 06:58 AM
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

02-16-2012, 08:03 AM
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.