TheMrBanks
New Member
- Joined
- Apr 23, 2018
- Messages
- 1
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
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