For Excel 2007 copy visible cell only is only thru for few number
Hello,
I have tested that for Excel 2007, the copy visible cells only can work for
only fiew numbers of rows. My spreadsheet has more than 55 000 rows and when
I do filtering and I want to copy only visible cells, it can not works it
says it is too complex.
Is there anyway to solve this problem. I have to separeae all the 2006
Purchas Order lines since excell has only 65000 lines plus.
Thanks for any idea provided.
--
H. Frank Situmorang
|