hello. I have made a user form that currently checks for used rows in Sheet named "calc" and pastes the data on to the next row. I want to edit this a bit. I have written unique codes in column A of sheet "calc". I want the macro to check the userform label "Label1" for the code and paste the data in front of the matching code. The user form has ten input items, so the macro will check the label and paste those entries infront of code. Currently these items are pasted in next unused row. Kindly note that the code is alpha numeric.
Last edited: