Context
I can currently search for an ID and populate values in my userform.
I can amend or change values and click an update button and it uploads the new data - code below:
If (TBID1.Text) = ws.Cells(i, 1) Then ' loop to find relevant ID within the data
ws.Cells(i, 1) = TBID1.Text...