我想要將每日更新表range(A3:C3)的資料再點選"匯入總表"的按鈕後,匯入到未平倉量總表當中,並依時間往下
匯入總表的VBA語法如下
Private Sub 匯入總表()
Dim a As String
Dim b As String
Dim c As String
a = Cells(3, 1)
b = Cells(3, 2)
c = Cells(3, 3)
Worksheets("未平倉量總表").Select
h = Range("B2").End(xlDown).Row
Cells(h + 1, "B") = a
Cells(h + 1, "C") = b
Cells(h + 1, "D") = c
Application.CutCopyMode = False
Workbooks("未平倉數據").Save
End Sub
求如何修改?依這個語法寫下去,三筆資料還是會匯到"每日更新表"的活頁簿當中

