Help me write my first VBA script

[TheMrBanks]

Hi,


I'm basicly looking for a more advanced search and replace based on a list.


I have a file which contains a worksheet called "Name" and "Data".
On worksheet "Name" i have column D.

This column D contains text.
Example off this text: 1.AA


The column "H" "I" "J" contain the data that needs to be replaced with the correct value from the "Data" worksheet.


But here is the exeption The search and replace in column "H" "I" "J" only needs to be done on cells which contains data.
So the empty cells should be ignored.


Can you please help me to write this VBA script so i can save myself correcting 4000 lines?


See images for more info!

https://ibb.co/e7NS9H
https://ibb.co/dmjqUH


Keywords: VBA, LOOP, SEARCH, REPLACE

 

[hiker95]

TheMrBanks,

Welcome to the MrExcel forum.

It would help if we could see your actual raw data workbook/worksheets, and, what the results (manually formatted by you) should look like.


You can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com