+- Hack Forums (https://hackforums.net)
+-- Forum: Tech (https://hackforums.net/forumdisplay.php?fid=444)
+--- Forum: Coding (https://hackforums.net/forumdisplay.php?fid=151)
+---- Forum: Software Development (https://hackforums.net/forumdisplay.php?fid=118)
+---- Thread: [.NET] Macro Find and Replace EXCEL (/showthread.php?tid=4852899)
Macro Find and Replace EXCEL - EasyGh0st - Jun 6, 2015
Hello guys!! ^^
Someone can help me with a small macro in vba?
In excel i've a table with 3 columns.
COLUMN A -> List of 15.000 different products repeated
COLUMN B -> 250 different products about COLUMN A (Not repeated)
COLUMN C -> 250 products about COLUMN B (corrected)
I need to make a macro that find all 250 different products of COLUMN B in COLUMN A and replace in COLUMN A the reference of all products COLUMN C (corrected).
Help me please ^^
Thank you in advance ✌✌
* - Oscura - Jun 6, 2015
Use the Office Excel Library (you have to add it to your references). It's called Excel automation.
https://support.microsoft.com/en-us/kb/301982
* - EasyGh0st - Jun 6, 2015
Someone can help me with code? :)
* - Breakbot - Jul 8, 2015
a month later , but you can just record a new macro doing that task ( ctrl F seach and replace value ) and automated vlookup's .