Hi!

I did just find a thread on here that had exactly what I needed though I had one issue with it not replacing the former rows in the second sheet.
A code snippet looking up if there was a specific value in one column and then copying over several columns to another worksheet.

Someone who can provide me with the code or a hint on what I should add for it to replace the rows already in the second sheet, starting from a specific row?

Link to the thread http://www.excelforum.com/excel-prog...ns-with-i.html

Best Regards
Kimzi