Copy number criteria from Master to multiples sheets

[marreco]

Hi I need get data based criteria in column T from Master sheet and paste in 5 differents sheets.



My Sheets
1 - Master (200 thausand rows, 56 columns), criteria in column T
2 - Entry_Data -> (Paste here all data based criteria which start 1* and 2*, in column T) e.g 1102, 2353 etc
3 - CFOP_5403 -> (Paste here all data based criteria 5403 in column T)
4 - CFOP_5102 -> (Paste here all data based criteria 5102 in column T)
5 - Out_Data -> (Paste here all data based criteria If not 5403, 5102 and not start 1* and 2*, in column T)

Peice of my data, look at column T

Tipo_Lanc	UF	Fis/Jur	CNPJ	RAZAO SOCIAL	NF	Data Emiss縊	DT_Fiscal	Data Lan軋mento	PRODUTO	DESCRICAO	NUM_ITEM	Unid	LISTA	NCM	Monit/Liber	EAN	MVA Original	MVA	CFOP	CST	QUANTIDADE	PF UNIT	PF TOTAL	VLR LIQ UNIT	VLR LIQ ITEM	VL UNIT NF	TOTAL NF	VL UNIT LIQ NF	TOTAL LIQ NF	DESC. TOT	DESCONTO	REPASSE	VC	BC	ICMS	BC N縊 Escriturado	ICMS N縊 Escriturado	ALIQ ICMS	APROPRIA	BC ICMS ST	ICMS ST	ALIQ INTERNA	DEB ICMS	IPI	CAT ANVISA	TIPO PRODUTO	TIPO DESCONTO	% DESCONTO	PMC	PMC FCIA POP	% REDUTOR ANVISA	CROSS	INDICADOR ICMSS	BC ICMS ST REC	ICMS ST REC
C	ES	2656	4,55439E+13	CARREFOUR COM E IND LTDA	2940178	01/10/2019	01/10/2019	01/10/2019	301452	FUROSEMIDA 40MG C 30 CAPS BIO	1	CX	LP	30049076	M	7,89618E+12	38,24	38,24	5403	510	2	11,85	23,7	9,48	18,96	11,85	23,7	9,48	18,96	4,74	4,74	0	18,96	18,96	3,22	0	0	17	N	16,38	0	17	0	0	Generico	Generico	Comercial	20	16,38	0	0	N	1	0	0
C	ES	2656	4,55439E+13	CARREFOUR COM E IND LTDA	2940571	01/10/2019	01/10/2019	01/10/2019	100000	AAS PROTECT 100MG C 30 COMP	8	CX	LN	30049024	M	7,8976E+12	33,29	33,29	5403	510	6	12,71	76,26	12,08	72,45	12,71	76,26	12,075	72,45	3,81	3,81	0	72,45	72,45	12,32	0	0	17	N	50,82	0	17	0	0	Similar	Similar	Comercial	5	16,94	0	0	N	1	0	0
C	ES	2656	4,55439E+13	CARREFOUR COM E IND LTDA	2940571	01/10/2019	01/10/2019	01/10/2019	100080	ALDACTONE 25MG C 30 COMP (NOVO)	5	CX	LP	30043220	M	7,89127E+12	38,24	38,24	5403	210	1	24,36	24,36	23,14	23,14	24,36	24,36	23,14	23,14	1,22	1,22	0	24,25	23,14	3,93	0	0	17	S	29,64	1,11	17	0	0	Referencia	Marca	Comercial	5	33,68	0	0	N	1	0	0
C	ES	2656	4,55439E+13	CARREFOUR COM E IND LTDA	2940571	01/10/2019	01/10/2019	01/10/2019	100286	ARFLEX 200MG C 12 CAPS	16	CX	LP	30049079	M	7,8981E+12	38,24	38,24	1103	10	1	46,75	46,75	42,54	42,54	46,75	46,75	42,54	42,54	4,21	4,21	0	44,98	42,54	7,23	0	0	17	S	56,87	2,44	17	0	0	Referencia	Marca	Comercial	9	64,63	0	0	N	1	0	0
C	ES	2656	4,55439E+13	CARREFOUR COM E IND LTDA	2940571	01/10/2019	01/10/2019	01/10/2019	101681	GLIFAGE XR 500MG C 30 COMP	10	UN	LP	30049049	M	7,89172E+12	38,24	38,24	5403	510	10	6,38	63,8	4,79	47,85	6,38	63,8	4,785	47,85	15,95	15,95	0	52,92	47,85	8,13	0	0	17	S	77,62	5,07	17	0	0	Referencia	Marca	Comercial	25	8,82	5,4	0	N	1	0	0
C	ES	2656	4,55439E+13	CARREFOUR COM E IND LTDA	2940571	01/10/2019	01/10/2019	01/10/2019	102159	LOXONIN 60MG C 15 COMP	2	CX	LP	30049029	M	7,89741E+12	38,24	38,24	6102	510	2	20,62	41,24	19,59	39,18	20,62	41,24	19,59	39,18	2,06	2,06	0	41,05	39,18	6,66	0	0	17	S	50,18	1,87	17	0	0	Referencia	Marca	Comercial	5	28,51	0	0	N	1	0	0
C	ES	2656	4,55439E+13	CARREFOUR COM E IND LTDA	2940571	01/10/2019	01/10/2019	01/10/2019	102296	MICROVLAR C 21 DRG	1	CX	LP	30066000	M	7,89111E+12	38,24	38,24	5403	510	2	5,84	11,68	5,38	10,75	5,84	11,68	5,375	10,75	0,93	0,93	0	11,39	10,75	1,83	0	0	17	S	14,53	0,64	17	0	0	Outros	Marca	Comercial	8	8,07	4,19	0	N	1	0	0
C	ES	2656	4,55439E+13	CARREFOUR COM E IND LTDA	2940571	01/10/2019	01/10/2019	01/10/2019	300268	ATENOLOL 25MG C 30 COMP MED	12	CX	LP	30049042	M	7,89642E+12	38,24	38,24	5403	10	6	4,7	28,2	1,27	7,61	4,7	28,2	1,2683	7,61	20,59	20,59	0	9,64	7,61	1,29	0	0	17	S	19,5	2,03	17	0	0	Generico	Generico	Comercial	73	6,5	3,3	0	N	1	0	0
C	ES	2656	4,55439E+13	CARREFOUR COM E IND LTDA	2940571	01/10/2019	01/10/2019	01/10/2019	301525	HIDROCLOROTIAZIDA 25MG 30CP MED	15	CX	LP	30049063	M	7,89106E+12	38,24	38,24	5102	510	4	3,49	13,96	0,7	2,79	3,49	13,96	0,6975	2,79	11,17	11,17	0	3,96	2,79	0,47	0	0	17	S	9,64	1,17	17	0	0	Generico	Generico	Comercial	80	4,82	1,8	0	N	1	0	0
C	ES	2656	4,55439E+13	CARREFOUR COM E IND LTDA	2940571	01/10/2019	01/10/2019	01/10/2019	301545	IBUPROFENO 100MG GTS 20ML MED	4	CX	LN	30049049	M	7,89642E+12	33,29	33,29	5403	10	2	10,9	21,8	4,36	8,72	10,9	21,8	4,36	8,72	13,08	13,08	0	9,71	8,72	1,48	0	0	17	S	14,53	0,99	17	0	0	Generico	Generico	Comercial	60	14,53	0	0	N	1	0	0
C	ES	2656	4,55439E+13	CARREFOUR COM E IND LTDA	2940571	01/10/2019	01/10/2019	01/10/2019	301878	NISTATINA+OX ZINCO POM 60G MED	11	CX	LN	30049099	M	7,89642E+12	33,29	33,29	5403	10	13	16,83	218,79	7,07	91,89	16,83	218,79	7,0685	91,89	126,9	126,9	0	101,05	91,89	15,62	0	0	17	S	145,79	9,16	17	0	0	Generico	Generico	Comercial	58	22,43	0	0	N	1	0	0
C	ES	2656	4,55439E+13	CARREFOUR COM E IND LTDA	2940571	01/10/2019	01/10/2019	01/10/2019	302177	SIMETICONA 125MG C 10 CAPS EMS	14	CX	LN	30049099	M	7,896E+12	33,29	33,29	2356	510	3	15,99	47,97	5,6	16,79	15,99	47,97	5,5967	16,79	31,18	31,18	0	23,72	16,79	2,85	0	0	17	S	57,54	6,93	17	0	0	Outros	Marca	Comercial	65	21,31	0	0	N	1	0	0
C	ES	2656	4,55439E+13	CARREFOUR COM E IND LTDA	2940571	01/10/2019	01/10/2019	01/10/2019	304663	CLORID NARATRIPT 2,5MG 10CPR NQ	7	UN	LP	30049099	M	7,8953E+12	38,24	38,24	2208	310	4	21,09	84,36	16,87	67,49	21,09	84,36	16,8725	67,49	16,87	16,87	0	67,49	67,49	11,47	0	0	17	N	58,32	0	17	0	0	Generico	Generico	Comercial	20	29,16	0	0	N	1	0	0
C	ES	2656	4,55439E+13	CARREFOUR COM E IND LTDA	2940571	01/10/2019	01/10/2019	01/10/2019	400889	MYLICON GTS 15ML	13	CX	LN	30049099	M	7,89621E+12	33,29	33,29	1245	510	2	17,48	34,96	16,43	32,86	17,48	34,96	16,43	32,86	2,1	2,1	0	32,86	32,86	5,59	0	0	17	N	23,3	0	17	0	0	Similar	Similar	Comercial	6	23,3	0	0	N	1	0	0
C	ES	2656	4,55439E+13	CARREFOUR COM E IND LTDA	2940571	01/10/2019	01/10/2019	01/10/2019	401041	PEPSAMAR 20X10 COMP	9	CX	LN	30049099	M	7,8976E+12	33,29	33,29	5403	10	1	70,6	70,6	67,07	67,07	70,6	70,6	67,07	67,07	3,53	3,53	0	70,07	67,07	11,4	0	0	17	S	84,69	3	17	0	0	Outros	Marca	Comercial	5	94,1	0	0	N	1	0	0

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col><col><col><col><col span="3"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

Thank you!!

 

[marreco]

Hi someone can help me?

 

[marreco]

Hi

Cross-Post
https://www.excelforum.com/excel-pr...m-master-to-multiples-sheets.html#post5219706