copy paste based on drop down code

[d0wnt0wn]

Hi there im looking for some code that I can use like this

i have drop down menus on sheet 1 with the numbers 1 to 10 in cells a1-a10
depending on which one i select it copys a cell from sheet 2 and pastes it to sheet 1 in column B next to the drop down menu i used

any ideas???

 

[rs2k]

Does it have to be code?
Would VLOOKUP not do?

Colin.

 

[d0wnt0wn]

yes it must be code..... i am actually trying to paste the comment that is in the cell not neccesarily the cell itself

 

[Von Pookie]

See:
http://www.mrexcel.com/board2/viewtopic.php?t=178733