Hello!
I will be grateful for your help on how to create, if possible, a drop down list (all values in list refer to a specific sheet in the same workbook) in such way that, when value is chosen, I can click on the cell and it will lead me to the exact cell with the same value on another sheet of the same workbook.
If my drop down list is in Cell B3 on the sheet dd_list, and if I choose 2, then I would like upon making that choice being able to click on B3 and get to B4 on another sheet called list.
I am attaching a workbook in case it can be easier to see.
Thank you very much!
Bookmarks