oras na para magtulungan tayo, wahahahaha! un din kasi ginagawa ko ngayon
Sakto hehe! May ginagawa kasi ako ngaung template sa Excel with saving functionality sa separate sheet (next empty row). Problema ko, merong range sa source na kelangan din copy sa kabilang sheet. Eto ung code ko so far, di pa kasama ung range na dapat ma copy din:
Private Sub CommandButton3_Click() 'save to local database
If Range("B1:B7").Text = "" Then
MsgBox "No data to save.", vbInformation, "Call Log Form"
Else
Sheets("Database").Activate
Application.ScreenUpdating = False
Dim sh As Worksheet
Dim LR As Long
LR = Sheets("Database").Range("B" & Rows.Count).End(xlUp).Row + 1
If LR < 6 Then LR = 6
Sheets("BTO Template").Range("b1:b7").Copy
Sheets("Database").Range("B" & LR).PasteSpecial xlPasteValues, xlPasteSpecialOperationNone, False, True
Sheets("BTO Template").Range("A10").Copy
Sheets("Database").Range("I" & LR).PasteSpecial xlPasteValues, xlPasteSpecialOperationNone, False, True
Sheets("BTO Template").Range("A19").Copy
Sheets("Database").Range("J" & LR).PasteSpecial xlPasteValues, xlPasteSpecialOperationNone, False, True
Sheets("BTO Template").Range("B29").Copy
Sheets("Database").Range("K" & LR).PasteSpecial xlPasteValues, xlPasteSpecialOperationNone, False, True
Application.CutCopyMode = False
Application.ScreenUpdating = True
End If
End Sub
Any thoughts sirs?