Query with macro

I want to run a macro that does the following every time I open a salary sheet:

1. If column N displays the code 2102, 2111, 2112, 2201, 2101, 2301, 2312 then copy the name displayed in column H and paste this to Column AL.and add the code 2102 after the name.
2. If column N displays the code 2102, 2111, 2112, 2201, 2101, 2301, 2312 then copy the text displayed in column F to column AM.

However, I'm not sure what type of formula I should use If Statement, Vlookup?