VBA for simple data copying

[dcm926]

Hello all,

I am very new to VB. I am doing a project for work and need to write a simple macro to copy data from one column to another in one sheet. I have part numbers in column "C", a lot of which are repeating. Column "F" contains the same part numbers, no repeating, and in cells "G" and "H" are the descriptions of the parts.

So I need a macro to check column "F" for a value that's in column "C" and when it finds that value, copy the corresponding information from "G" and "H" to "D" and "E".

Hope the description is clear enough, and thank you for any help in advance.

 

[VoG]

You should be able to use VLOOKUP formulas for that. See http://www.contextures.com/xlFunctions02.html

 

[dcm926]

That worked great! Thank you very much for showing me that function. Some of these cells will come up "#N/A", could I possibly have an "IF" statement or some other function to just leave those cells blank?

Thanks again.

 

[VoG]

Try like this

=IF(ISNA(your formula),"",your formula)

 

[dcm926]

Perfect! Thanks for the help, I appreciate it.