Eu tenho uma tabela de 10000 linhas X 50 colunas. A tabela está toda em uma planilha e estou planejando dividir essa planilha em vários sheers com base em valores em duas colunas (colunas número 5 e 1, respectivamente para eu ser específico).
EDIT: Para esclarecer, o que estou tentando fazer aqui é dividir os dados com base na coluna no.5 e depois dividir as folhas resultantes em outras folhas com base na coluna 1.
Encontrei alguns códigos VBA que conseguiram dividir os dados em várias planilhas com base nos valores da primeira coluna aqui .
Minha pergunta aqui é: É possível modificar esse script para dividir os dados em planilhas com base na coluna número 5 e, em seguida, aplicar outro nível à divisão com base na coluna 1 em 1 go? ou preciso aplicar os scripts dessas duas etapas 1 por 1?
Veja alguns dados de reprodução para fins de teste no formato CSV.
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
Peço desculpas por essa pergunta, mas sou novo no Excel e ainda na fase de aprendizado. Apreciado.