[EasyGh0st]

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]

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]

Someone can help me with code? :)

[Breakbot]

a month later , but you can just record a new macro doing that task ( ctrl F seach and replace value ) and automated vlookup's .