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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to setup autoconnection between matching cells in 2 dif WSs
Assuming your numbers are in column A on both sheets in any order, put
this formula in B1 of Page001: =HYPERLINK("#Page002!R"&MATCH(A1,Page002!A:A,0)&"C 1","jump") and this one in B1 of Page002: =HYPERLINK("#Page001!R"&MATCH(A1,Page001!A:A,0)&"C 1","jump") Then copy both formulae down. The will put the word "jump" next to each number, and if you click this cell it will take you to the corresponding cell in column A of the other sheet. Click on "jump" in that sheet and it will take you back to the previous sheet. (I seem to have answered a lot of questions about hyperlinks in the last couple of days). Hope this helps. Pete On Nov 6, 12:24*am, jbdahl1 wrote: 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. |
Reply |
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 |