Ok so in short I am very new to this, and have been doing OK until this stupid roadblock.
I have a bunch of ID numbers in column A of sheet one. when I double click one, I need the value in that cell when double clicked to be copied into cell b5 in sheet2 and the focus of the screen change from...