Looks for some codes than copy

[jmaocubo]

Hello everyone ...

I need your help.

I'm trying to create a VBA code that allows me to look for a column that have certain pre-defined codes. When he finds, copy values to another Sheet.


trying:
Copy to column N (Start N53) comparing the value in column L of the "Relatório Descontos", with Column A of the "Lista Recursos CCS".

After comparing copy the value of column I of the "Lista Recursos CCS" for the column N of the "Relatório Descontos" columns E and F to P and Q.

Note: The codes (column A) can exit or not.... thats all the codes possible and every time i use that workbook only a parcial of that list will exist.



Please see attach file.


Thanks in advance

Miguel

[jmaocubo]

Anyone???????????????????'