rahul.sharma
July 4th, 2008, 07:47 AM
Hi
I have a VBA programming problem. I have a data with over 200000 rows. But limitation in excel for over
65000 rows doesn't allow to fit data in one excel sheet. So i splitted the data in 20000 rows chunks.
But now i have one problem : I have one column, column_nbr that has value 1 to 99.
I want when data get splitted one column value should not distributed in 2 worksheet .
i.e., If sheet 1 has data for column_nbr 1 to 20 then for col 20 all values should be in same sheet
and same time maintain the condition of 20000 rows in one sheet only.
Can anybody help me for code for above problem...
I have a VBA programming problem. I have a data with over 200000 rows. But limitation in excel for over
65000 rows doesn't allow to fit data in one excel sheet. So i splitted the data in 20000 rows chunks.
But now i have one problem : I have one column, column_nbr that has value 1 to 99.
I want when data get splitted one column value should not distributed in 2 worksheet .
i.e., If sheet 1 has data for column_nbr 1 to 20 then for col 20 all values should be in same sheet
and same time maintain the condition of 20000 rows in one sheet only.
Can anybody help me for code for above problem...