Select in drop down and automatically takes you to the worksheet
I'm using Prof. Excel 2003.
After selecting in a drop down a four digit number in a validation cell in
worksheet 1, I am attempting to have a direct 'link' to that number in
another worksheet 2 in the same workbook automatically.
Any suggestions?
|