How to automatically copy cells into other ones on different sheet.

[thebiguy]

Hi,

Was wondering how to automatically get the name of something in Sheet 2 from Column A into Column E-K in the same column, depending on what letter I put in Column H in Sheet 1?

The index of which column the name is put depending on what letters are put in is below.

WB - Column E

B - Column F

OM - Column G

M - Column H

OP - Column I

H - Column J

L - Column K

Thanks!

TBG

 

[thebiguy]

Anyone?