02.06.2019, 12:14
ich möchte in meiner Liste nachvollziehen welche Buchnummer die Wäschenummer hatte, also zumindest wer sie davor hatte. ist das überhaupt machbar??? :20:
Sub Makro1()
'
' Makro1 Makro
'
'
Range("A2:C3").Select
ActiveWorkbook.Worksheets("Journal").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Journal").Sort.SortFields.Add2 Key:=Range("A2:A3") _
, SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("Journal").Sort
.SetRange Range("A2:C3")
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
End Sub
Sub Makro1()
ActiveWorkbook.Worksheets("Journal").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Journal").Sort.SortFields.Add2 Key:=Range("A:A") _
, SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("Journal").Sort
.SetRange Range("A:C")
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
lngRow = getRow + 1
Set wks = Worksheets("Journal")
wks.Cells(lngRow, 1).Value = Now()
wks.Cells(lngRow, 2).Value = Target.Value
wks.Cells(lngRow, 3).Value = Target.Offset(-1, 0).Value
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
lngRow = getRow + 1
Set wks = Worksheets("Journal")
wks.Cells(lngRow, 1).Value = Now()
wks.Cells(lngRow, 2).Value = Target.Value
wks.Cells(lngRow, 3).Value = Target.Offset(-1, 0).Value
Call Makro1
End Sub