Saya buat script baru sepert ini :
Sub NewSave()
Dim rngX As Range
Dim strdata1, strdata2
'Find with multiple criteria
'Copy data from rekam a sheet
Application.ScreenUpdating = False
Sheets("form").Select
Range("A1").FormulaR1C1 = "=INPUT!R[2]C[1]"
Range("a:a").Select
Selection.Copy
With Sheets("INPUT")
strdata1 = .Range("B1").Value 'jenis kayu
strdata2 = .Range("B3").Value 'batch no
End With
If Application.WorksheetFunction.CountIfs(Worksheets("database").Range("2:2"), strdata1, Worksheets("database").Range("1:1"), strdata2) > 0 Then
'if Data was found------------------------------------------------------------------------------------------------------
Worksheets("database").Select
Worksheets("database").Range("2:2").Find(strdata1, LookIn:=xlValues, MatchCase:=False).Activate
Do Until ActiveCell.Offset(-1, 0).Value = strdata2
Worksheets("database").Range("2:2").FindNext(After:=ActiveCell).Activate
Loop
ActiveCell.Offset(-1, 0).Select
'Past data changes
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("input").Select
MsgBox "Row Updated"
Else
'if Data was not found------------------------------------------------------------------------------------------------------
'Copy Macro
Sheets("Input").Select
Range("B3").Select
ActiveCell.FormulaR1C1 = "=MAX(COUNTIF(database!r2c1:r2c500,input!r1c2)+1)"
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("form").Select
Range("a1").FormulaR1C1 = "=MAX(COUNTIF(database!r2c1:r2c500,input!r1c2)+1)"
Range("a:a").Offset(0, 0).Select
Selection.Copy
Sheets("database").Select
Worksheets("DATABASE").Cells(Rows.Count, "A").End(xlUp).Offset(0, 1).PasteSpecial Paste:=xlPasteValues, Transpose:=False
'ActiveSheet.Paste
ActiveCell.Offset(1).EntireColumn.Insert
Sheets("input").Select
MsgBox "Penyalinan berhasil!", vbInformation, "Informasi"
End If
Application.ScreenUpdating = True
End Sub
file terlampir ya
saya hanya agak bingung dengan batch numbernya.. semoga tdk salah asumsi yah
untuk rekan lain,silahkan menambahkan/ada solusi lain...