I am trying to move data from a user form to an excel sheet and the code below does what I need for the first instance. The form may contain up to 100 text boxes txtUnits1, txtUnits2, txtUnits3 etc
What I need to do is for every text box move the corresponding data. If there isn't any values...