I have a table of 10000 rows X 50 columns. The table is all in one sheet and I am planning to split that sheet into multiple sheers based on values in two columns (columns number 5 and 1, respectively for me to be specific).
EDIT: To clarify, what I am trying to do here is to split the data based on column no.5 then split the resulting sheets into further sheets based on column 1.
I have found some VBA code that was able to split data into multiple sheets based on the values in the first column here.
My question here is: Is it possible to modify that script in order to split the data into worksheets based on column number 5, then apply another level to splitting based on column 1 in 1 go? or do I need to apply the scripts of these two steps 1 by 1?
Here's some play data for your testing purposes in CSV format.
Dummy 1,Dummy 2,Dummy 3,Dummy 4,Dummy 5,Dummy 6,Dummy 7,Dummy 8 Class 1,0.6,0.4,0.4,A,0.1,0.6,0.2 Class 2,0.4,0.1,0.2,A,0.8,0.3,0.5 Class 3,0.2,0.9,0.9,B,0.8,0.3,0.9 Class 1,0.4,0.6,0.5,B,0.8,0.9,0.8 Class 3,0.5,0.3,0.3,A,0.5,0.1,0.4 Class 2,0.4,0.2,0.0,A,0.7,0.3,0.2 Class 1,0.4,0.2,0.4,A,0.4,0.9,0.9 Class 4,0.1,0.3,0.8,A,0.5,0.3,0.5 Class 1,0.5,0.3,0.1,B,0.3,0.2,0.2 Class 2,0.4,0.5,0.6,B,0.1,0.3,0.2 Class 3,0.4,0.8,0.3,B,0.4,0.2,0.5 Class 1,0.5,0.1,0.9,B,0.5,0.6,0.6 Class 3,0.7,0.1,0.9,C,0.0,0.9,0.8 Class 2,0.1,0.2,0.5,C,0.0,0.1,0.7 Class 1,0.4,0.5,0.4,C,0.0,0.4,0.2 Class 4,0.7,0.4,0.1,C,0.9,0.1,0.9 Class 1,0.5,0.5,0.0,B,0.5,0.2,0.1 Class 2,0.5,0.8,0.6,B,0.6,0.6,0.9 Class 3,0.7,0.8,0.6,B,0.4,0.2,0.0 Class 1,0.6,0.2,0.6,A,0.6,1.0,1.0 Class 3,0.6,1.0,0.1,A,0.7,0.9,0.5 Class 2,0.4,0.7,0.7,C,0.5,0.7,0.2 Class 1,0.2,0.8,0.3,C,0.1,0.6,0.4 Class 4,0.5,0.1,0.0,D,0.9,0.1,0.5 Class 1,0.4,0.0,1.0,D,0.7,0.0,1.0 Class 2,0.8,0.5,0.4,B,0.0,0.2,0.6 Class 3,0.4,0.5,0.7,A,0.1,0.0,0.0 Class 1,1.0,0.3,0.6,C,0.1,0.4,0.8 Class 3,0.1,1.0,0.0,D,0.5,0.9,0.1 Class 2,0.7,0.3,0.7,B,0.1,0.9,0.4
I apologize for this question but I am new to excel VBA and still in the learning phase. Appreciated.