Finding a specific row and inserting data

Hello everybody

My problem is fairly simple i guess, but I´m a beginner when it comes to VBA.
I have a column with lots of rows. I want to locate a specific one and insert some data into this row at specific columns. This is what i have come up with so far:

Please Login or Register  to view this content.

It doesn´t work for me - whats wrong?
In your answers, if you post code, please comment on it so i can understand - thanks and best regards.

Hi,

This would be a lot easier to help if you uploaded your workbook please, including an example of what the final product should look like.

Thanks

Hi, if you could be clear about which part of the code does not work. Have you tried stepping through the code and checking the values of any variables to see which ones might be failing? Need more info.

alright, here is the file and what I want to happen.
Within the sheet "Production Data" theres is a box called Initial bending strengt. Here data a saved and stored in the sheet "Initial bending strenght" according to a certain date. I then want to store inition loss aswell under the correct date and board nr. So the save macro for the ignition loss should shearch for the row containing the right date and board nr and insert the information in the correct columns in that row.

Best regards

Thank you so much for spending time on this, it worked perfectly with the changes you´ve added. Best Regards

You're welcome

Please don't forget to mark this thread as solved, and please click on the * next to any post(s) to say thanks to the poster(s)

Originally Posted by ajryan88

Hi,

Your code works fine with a few minor changes (marked in red):

Please Login or Register  to view this content.

Hope this helps

This is super - One last thing - Can you make it dependent on board nr aswell as date, so that it needs to look for date and board nr.?

Originally Posted by xladept

Hi DK,

Try this:

Please Login or Register  to view this content.

Thanks First i tried this myself with and extra For Each cell command:

Please Login or Register  to view this content.

It doesn´t seem to work though :/

Best regards

I'm not 100% sure what you are trying to achieve, so I haven't actually tested this code apart from making sure that it compiles, but is this what you were trying to do?

Please Login or Register  to view this content.

Originally Posted by ajryan88

I'm not 100% sure what you are trying to achieve, so I haven't actually tested this code apart from making sure that it compiles, but is this what you were trying to do?

Please Login or Register  to view this content.

This worked the way I had hoped, so thanks alot you guys!

Best regards

You're welcome