gruhnelliot
New Member
- Joined
- Jun 4, 2013
- Messages
- 14
I want to hyperlink two numerical lists on different worksheets. Is this possible?
For example, each person in this test worksheet is assigned a number (18-01, 18-02, etc.)
WORKSHEET # 1
<tbody>
</tbody>
Is there a way to link the customer numbers in worksheet# 1 to the corresponding numbers in worksheet # 2?
WORKSHEET # 2
<tbody>
</tbody>
For example, each person in this test worksheet is assigned a number (18-01, 18-02, etc.)
WORKSHEET # 1
Customer # | First | Last | |
18-01 | Ted | Mosby | |
18-02 | Chris | Smith | |
18-03 | Tony | Adams | |
18-04 |
<tbody>
</tbody>
Is there a way to link the customer numbers in worksheet# 1 to the corresponding numbers in worksheet # 2?
WORKSHEET # 2
Customer # | Jan | Feb | Mar | April |
18-01 | 50 | 0 | 20 | 100 |
18-02 | 25 | 40 | 50 | 50 |
18-03 | 0 | 0 | 0 | 0 |
18-04 | 0 | 0 | 0 | 0 |
<tbody>
</tbody>