I want to put a generic script/macro onto a button that would look at the value of cell A1 and then move to the Worsheet called "Sheet" + A1 in my current workbook.
How could I do that???
For example A1 contains the value 15. When I click on my button I want it to take me to Sheet15 in the current workbook. If I click on a different button I want it to take me to the Worsheet Info15 in the workbook...
The key is concatenating the word Sheet or Info or whatever with the value that is found in A1 and then Hyperlinking to that worksheet.
Anyone got ideas?
Bookmarks