Hello,i need to put the Ndoc (first row) twice if it has a value in both columns (ICMS, IPI) if the value is 0 in any of these rows then it just needs to type Ndoc once.
i tried this but it doesnt check if is ICMS or IPI
i dont know which function i should be usingFor Each Cell In Sheets(1).Range("I3:J106") If Cell.Value > "0" Then Workbooks("TESTE.xlsx").Worksheets("HOJA").Range("A3:A106").Copy Workbooks("02. FICHA DE LANÇAMENTO NF ENTRADA _BDC.xls").Worksheets("BDC").Range("E2").PasteSpecial Paste:=xlPasteValues Workbooks("02. FICHA DE LANÇAMENTO NF ENTRADA _BDC.xls").Worksheets("BDC").Range("O2").PasteSpecial Paste:=xlPasteValues Workbooks("02. FICHA DE LANÇAMENTO NF ENTRADA _BDC.xls").Worksheets("BDC").Range("X2").PasteSpecial Paste:=xlPasteValues
Thx in advance
Bookmarks