I'm creating a userform that needs to update to an existing excel tabel named "CFSData"<BR><BR>I have a submit button (cmdSubmit) that I currently have the following vba for:
Private Sub cmdSubmit_Click()
Dim nextrow As Integer
'countA function
nextrow = WorksheetFunction.CountA(Sheets("Data").Range("A:A")) + 1
Sheets("data").Cells(nextrow, 1) = Now
Sheets("data").Cells(nextrow, 2) = frmCFSTracker.comboMgr.Value
Sheets("data").Cells(nextrow, 3) = frmCFSTracker.comboSup.Value
Sheets("data").Cells(nextrow, 4) = frmCFSTracker.comboSpecialist.Value
Sheets("data").Cells(nextrow, 5) = frmCFSTracker.comboBehavior.Value
Sheets("data").Cells(nextrow, 10) = frmCFSTracker.txtTime.Value
Sheets("data").Cells(nextrow, 18) = frmCFSTracker.optTotalAHT.Value
Sheets("data").Cells(nextrow, 19) = frmCFSTracker.optCSAT.Value
Sheets("data").Cells(nextrow, 20) = frmCFSTracker.optTransfers.Value
Sheets("data").Cells(nextrow, 21) = frmCFSTracker.optCustIR.Value
End Sub
I found that this can only add data to the worksheet (named: "data") which contains the table (CFSData) I would actually like the data to go into .. I need the data to be inserted into the table instead of adding additional rows outside of it...
Bookmarks