Copy number criteria from Master to multiples sheets

marreco

marreco

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



Thank you!!
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

G
  • Question Question
Formula to count with multiple criteria and exclude from a separate column, then sort by count in one cell with spill
Replies
0
Views
571
Greenbehindthecells
G
W
  • Solved
How to count all the headlines listed in column CT between dates of July 1 and July 31 2019 listed in column CT
2
Replies
10
Views
1K
wmichael
W
C
  • Question Question
copy dynamic range to another sheet in another workbook
Replies
1
Views
2K
footoo
F
R
  • Question Question
Sum If, multiple criteria
Replies
2
Views
592
AhoyNC
A
D
  • Question Question
Complex - Multiple Criteria
18 19 20
Replies
192
Views
14K
dunmore83
D

Forum statistics

Threads
1,223,886
Messages
6,175,191
Members
452,616
Latest member
intern444

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top