Hi all,
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.
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?
thanks,
Andy
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.
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?
thanks,
Andy