Macro for copy cell, find and replace in specific place

[cosiek]

Hi,
I was trying to figure out the macro for coping, finding and replaing the content. However, still cannot figure it out, as I am learning macro.

I want macro to do:

1. Copy value from E2
2. Search in D2 src="%"
3. Replace copied value inside src to have src="yyy.jpg"
4. Follow the process till the rows are not populated

Screen of file:
1.JPG

Attached the file with the needed change.

Awaiting for your kind help.
Thank you.
Regards,
Jakub

[Richard Buttrey]

It doesn't really need a macro, a formula will do that.

Please Login or Register  to view this content.

If you do need a macro just get the macro to copy that formula into the required range.

[cosiek]

Thank you it works perfectly!