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???
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???