| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to setup autoconnection between matching cells in 2 dif WSs
Is there a way you can have two columns of data on two different worksheets
find each others matching value, then have them become hyperlinks, in the sense; Say you have Page001 WS, column A has value 10, and Page002 WS, column A has a value in the column somewhere as well; can you have them find each other become linkable then while saying you do a Ctrl F for 10 in Column A you can click on the value 10 and it will take you to value 10 in Column A of Page002 WS and if you click it again it will take you back to Page001 WS column A value 10 again? Is there anyway to automate this procedure? Thanks for your time. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i setup tabbing order of cells? | Excel Discussion (Misc queries) | |||
| display a range of cells editible cells based on matching date | Excel Worksheet Functions | |||
| Help with Matching Text Fields - Then Moving the Matching Cells Side by Side | Excel Discussion (Misc queries) | |||
| Is there a way to setup word wrap within cells? | Excel Discussion (Misc queries) | |||
| How can i setup tab order of cells the way i want them? | Setting up and Configuration of Excel | |||
Threaded Mode
