I would like to activate a particular sheet by clicking a cell value in sheet1. The values in G41 to G70
** "Main"(Sheet1) contain the tab names ** various sheets in the same workbook.
Request for guidance.
Regards
I would like to activate a particular sheet by clicking a cell value in sheet1. The values in G41 to G70
** "Main"(Sheet1) contain the tab names ** various sheets in the same workbook.
Request for guidance.
Regards
So you want to open a particular tab that is listed in a cell by clicking in that cell. Is this a correct understanding?
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Use a hyperlink.
http://o ffice.microso ft.com/en-us/excel-help/create-a-link-to-another-cell-workbook-or-program-HP005199514.aspx
Because ** issues with our the server, you will have to type this out as the link will not work.
Last edited by alansidman; 03-09-2014 at 01:07 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks