Sub Listinoprezzi() Cancella2 p = 3 For a = 3 To 1000 If Foglio1.Cells(a, 1).Value = "Vendita" Then Foglio2.Cells(p, 1).Value = Foglio1.Cells(a, 2).Value Foglio2.Cells(p, 2).Value = Foglio1.Cells(a, 11).Value p = p + 1 End If Next a Range("A3:B100").Sort Key1:=Range("A3"), Order1:=xlAscending, Header:=xlNo End Sub |
Option Explicit Sub Listinoprezzi() Dim a As Long For a = 3 To 1000 If Foglio1.Cells(a, 1).Value = "Vendita" Then Foglio2.Cells(a, 1).Value = Application.WorksheetFunction.Round(Foglio1.Cells(a, 2).Value, 0) Foglio2.Cells(a, 2).Value = Application.WorksheetFunction.Round(Foglio1.Cells(a, 11).Value, 0) End If Next a Range("A3:A100").NumberFormat = "_(* #,##0.00_);_(* (#,##0.00);_(* ""-""??_);_(@_)" Range("A3:B100").Sort Key1:=Range("A3"), Order1:=xlAscending, Header:=xlNo End Sub |