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...
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. -- Regards Jonathan West - Word MVP www.intelligentdocuments.co.uk Please reply to the newsgroup wrote in message news:bdd415ff-f5cb-4bf2-b41d-334806ae4300@i76g2000hsf.googlegroups.com... > 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...
