What If commands

Hello,

I am updating a excel sheet that contain some matrix calculation, however the update I am doing should be streight forward.

what I am looking at is the following

1: If N6 = "CRT" Then copy AE3:AH4 to B14:E15 & copy AI3:AL4 to B6:E7
2: If N6 = "DLP Rear projection" Then copy AE5:AH6 to B14:E15 & copy AI5:AL6 to B6:E7
3: If N6 = "Front Projection Lens" Then copy AE7:AH8 to B14:E15 & copy AI7:AL8 to B6:E7
4: If N6 = "Front Projection Screen" Then copy AE9:AH10 to B14:E15 & copy AI9:AL10 to B6:E7
5: If N6 = "LG LED LCD" Then copy AE11:AH12 to B14:E15 & copy AI11:AL12 to B6:E7
6: If N6 = "LG Standard LCD" Then copy AE13:AH14 to B14:E15 & copy AI13:AL14 to B6:E7
7: If N6 = "Plasma" Then copy AE15:AH16 to B14:E15 & copy AI15:AL16 to B6:E7
8: If N6 = "Samsung LCD LED" Then copy AE17:AH18 to B14:E15 & copy AI117:AL18 to B6:E7
9: If N6 = "Samsung LCD Standard" Then copy AE19:AH20 to B14:E15 & copy AI19:AL20 to B6:E7
10: If N6 = "Sony LCD LED" Then copy AE21:AH22 to B14:E15 & copy AI21:AL22 to B6:E7
11: If N6 = "Sony LCD Standard" Then copy AE23:AH24 to B14:E15 & copy AI23:AL24 to B6:E7

Hope for some help on this.

Thank you in advance


Carsten