Help with VBA Code - Find cells with specific value, Copy/Paste value from adjacent colmns

Hi

I'm new to the forum and hoping you can help me. I have some experience with VBA but don't use this often.

I'm looking for code that will find every entry in my column (column C in my spreadsheet) that has a specific text string and then take the value from the same row in column E and copy this in to column D.

I have code to find the value but my copy paste only works on the changes my column header. Any help would be appreciated

Thanks

Apologies example spreadsheet now attached.

I have made the information generic in the spreadsheet and included the macro I have written so far.

In this exmaple I am looking to find all entries of 'Transcation 3' and replace the 0 found in column D with the value shown in column E. Once complete I have a macro which will delete all rows with 0 values in column D as I don't want these in my final output.

Thanks for your help

Does this help?

Please Login or Register  to view this content.

Yes perfect, I was also able to use for multiple variables which I was hoping. Thanks for you help with this