More than 65536 to new sheet

P

Pav

Hi,
Can this be done?
I'm downloading simple data that is something more than
65536 worth of rows and would like the unknown surplus to
go to Sheet2.

TIA
 
B

Bob Phillips

No, you need Quattro Pro or a database for this (or a re-design)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split a text file with more than 65536 lines over many worksheets 5
How to check a condition and write another cell 0
VLookup Won't Copy down (#REF! error) 1
Where to buy alternative themes for Word 2013? 0
Use multiple sheets to display and edit data? 0
Splitting data on sheets for more than 65536 rows... 1
Can I put more than 65536 rows in one Excel sheet? 2
How can I print rows that go outside of the page without shrinking the text? 0

Top