FORMATING ONE SHEET TO MOVE U TO ANOTHER
 

I want to be able to click on B7 on the species OID sheet and it take me to
E3 on example ID sheet. and vis-ver-sa

OR
if im on the species OID sheet and my mouse runs over B7 i want it to show
me wants in E3 on the example ID sheet.


This is SO CONFUSING!?!?!?!?

Thank You ahead of time!!




sheet title: species OID

A B C
D
3 EAR TAG PLASTIC EAR TAG METAL BACK TAG
4 Alabama
5 Alaska
6 Arizona
7 Arkansas X X X
8 California

Sheet title: ID examples
A B C D E

1 STATE Alabama Alaska Arizona Arkansas
2 BOVINE
3 EAR TAG PLACTIC 71ABC1234
4 EAR TAG METAL 71ABC1234
5 BACK TAG 71AB1234