Currently have a user form and data table where new entries in the user form go to the end of the data table in a worksheet called "Data Inputs", with the following relevant code:
Dim iRow2 As Integer
Dim Data1 As Range
iRow2 = Worksheets("Data Inputs").Cells(Rows.Count, 6).End(xlUp).Row + 1...