I'm looking for a solution for a dilemma I'm in..
On sheet 1 I have a dropdown box in cell A1 and B1 is an emtpy cell.
On sheet 2 I have the same dropdown box in A1 followed by a cell in B1 which I can type hours, for example "2".
Is there a way to tell Excel, that if the same word is active in the dropdown menu, it will transfer the number "2" to the empty cell on sheet 1, B1..??