Re: Need Help With Hyperlinking 2 Lists
<style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore
adding; color:black; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;}.xl63 {text-align:center; border:.5pt solid windowtext;}--></style>I apologize for the lack of details, I will try to explain it better here.
In worksheet # 1, I have a table where a group of people are assigned a file number, for example: John is assigned 18-01, Dave is assigned 18-02, and so on...
This is an example of the table in WS#1
18-01 | John |
18-02 | Dave |
18-03 | Chris |
<!--StartFragment--> <colgroup><col width="65" span="2" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>
In worksheet # 2, those same file numbers are in a table which show how much money each person has spent this year.
This is an example of the table in WS#2.
File # | JAN | FEB | MAR |
18-01
| 20$ | 10$ | 200$ |
18-02 | 10$ | 50$ | 2000$ |
18-03 | 0$ | 0$ | 0$ |
<tbody>
</tbody>
Is there a way to hyperlink each corresponding number (18-01, 18-02, and so on) from WS#1 to WS#2, and from WS#2 back to WS#1?
So, if I was in WS#1, my goal is to click "18-01" and it hyperlink me to "18-01" in WS#2. Does this make sense?
The list has hundreds of file numbers so manually doing it for each one isn't realistic.
<colgroup><col span="4"></colgroup><tbody>
</tbody>
<colgroup><col span="4"></colgroup><tbody>
</tbody>