Take values from user form to cells in a certain row

Hi,

I have a problem with looking up a certain value through a user form and then change the data in the row that value is in.

To find the right row I came to this code:

Formula:

Please Login or Register  to view this content.

To change the cells I had something like this in mind:

Formula:

Please Login or Register  to view this content.

What I want to achieve in text: There is product data in rows and columns. Through a user form I select the right product. In text boxes the data of this product appears. In a 2nd set of text boxes this data also appears. In this 2nd set of text boxes I change the data and leave the data in the 1st set of boxes untouched. By a command button the data from the 2nd set of boxes should be put in the right row, by looking up the original product from the 1st set of boxes.

Thanks for the help in advance!

Hmm, that was my thought as well, but does not work. Let's forget what I've set up so far, because I feel it is a bit of a mashup of different solutions. How would you tackle the problem I described without looking at the code?

I am not really sure, but the option of Bakerman2 actually solved it. And nope, there are no duplicates in this column. I can see why my try was way harder then the solution. By using the frow and application.match I got both problems tackled in one line. Thanks for the support!

I'm quite new to Macro's and VBA coding, so sometimes I struggle to find the right 'language'. This forum has been very helpful so far, so thanks again!