VBA prog'ing help

[rahulme81]

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...

 

[Jonathan West]

This group deals with VBA in Word, not Excel, so you aren't very likely to
find an expert here able to answer your question.

I suggest you re-post your question to the
microsoft.public.excel.programming group.