Bom dia,
Segue as macros como estou fazendo para conseguir o resultado. Copiei e colei separado como vc pediu. Uso na sequencia que enviei.
Como eu disse preciso que na coluna H (considerando a planilha ja organizada, por isso é a H mesmo) todas as linhas que nessa coluna os números apareçam com o valor negativo (essa macro que fiz faz isso mas não sei se é a melhor maneira).
Também preciso excluir a linha que aparece *Total (Coluna A - sempre aparece na ultima linha) e tudo que está abaixo dela (ainda não consegui uma que faça isso).
Sub Org()
'Importando dados
Workbooks.Open("\\vsboffice\AAL\Documentacao_administrativa\AAL1\Gestão de Estoque\Dados\Base.xls" _
.Worksheets("Base".Copy Before:=Workbooks("Executando.xlsm" _
.Sheets(1)
Workbooks("Base.xls".Activate
ActiveWorkbook.Close False
' Organizando Planilha
Columns("A:V".Select
Columns("A:V".EntireColumn.AutoFit
With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlBottom
.WrapText = False
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = False
.ReadingOrder = xlContext
.MergeCells = False
End With
With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
.WrapText = False
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = False
.ReadingOrder = xlContext
.MergeCells = False
End With
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 3
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 5
ActiveWindow.ScrollColumn = 6
ActiveWindow.ScrollColumn = 5
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 3
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 1
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 3
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 5
ActiveWindow.ScrollColumn = 6
Range("L2".Select
Selection.Cut
Range("L3".Select
ActiveSheet.Paste
Range("K2".Select
Selection.Cut
Range("K3".Select
ActiveSheet.Paste
ActiveWindow.ScrollColumn = 5
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 3
ActiveWindow.ScrollColumn = 2
Range("E2".Select
Selection.Cut
Range("E3".Select
ActiveSheet.Paste
Range("B2".Select
Selection.EntireRow.Delete
Range("B1".Select
Selection.EntireRow.Delete
Range("L9".Select
ActiveWindow.SmallScroll Down:=-15
ActiveWindow.ScrollColumn = 3
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 5
ActiveWindow.ScrollColumn = 6
ActiveWindow.ScrollColumn = 5
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 3
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 1
Range("A2".Select
Selection.EntireRow.Delete
Range("E11".Select
ActiveWindow.SmallScroll Down:=-9
Columns("A:A".Select
Selection.Delete Shift:=xlToLeft
Range("D11".Select
'Trocando os "." das datas para "/"
Columns("G:G".TextToColumns Destination:=Range("G1", DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
:=Array(1, 4), TrailingMinusNumbers:=True
' Continuar Organizar
Columns("G:G".EntireColumn.AutoFit
Range("A1:T2".Select
With Selection
.HorizontalAlignment = xlGeneral
.VerticalAlignment = xlCenter
.WrapText = False
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = False
.ReadingOrder = xlContext
.MergeCells = False
End With
With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
.WrapText = False
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = False
.ReadingOrder = xlContext
.MergeCells = False
End With
Range("G2".Select
Selection.ClearContents
For i = Cells(Rows.Count, 9).End(xlUp).Row To 3 Step -1
If Cells(i, 9).Value <= -1 Then
Cells(i, 9).EntireRow.Delete
End If
Next
'Apagando a linha em que a coluna A a primeira celula aparece vazia
Columns("A:A".Select
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.EntireRow.Delete
'Deletando a planilha Base (2)
Sheets("Base (2)".Select
ActiveWindow.SelectedSheets.Delete
End Sub