Code mapping from another sheet

[Pasha81]

Hi guys

basically I got 2 sheets - 'Sheet1' and 'Codes'

In sheet 1 I have many columns of info(irrelevant here), we focus on one Column N, there are codes in this column and depending on the code I need to enter an Asset Class in Column AG.

The Sheet (Codes) - has 2 columns with the code(column A) and its corresponding asset class in Column B.

A lot of the codes belong to the same asset class so dont be confused if u see the same asset class category twice


I need the macro to copy the correct asset class value from Column B(Sheet 'Codes) to Column AG of Sheet1.

hope that was simple.

thanks, please let me know if there are any questions

[shg]

In AG2 and copy down, =VLOOKUP(N2, Codes!$A$1:$B$107, 2, FALSE)

[Pasha81]

Thanks shg

But is it possible to write a macro to do it? because it is a page that will have new data everyday, and the columns will be dynamic as well