FORMATING ONE SHEET TO MOVE U TO ANOTHER

A

A. Gray

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Totals Lookup by month and year 3
How Can i Link With one sheet to another sheet in Row to Column 1
Somewhat complex code to copy data from one sheet to another 9
trying to get sheet 1 to recognize and move student names to pg 2 1
If ID # on one sheet isn't found on another... 4
using vlookup to find data outside a specified range 1
vlookup---using data outside the range specified in the formula 4
Compiling to one sheet 2

Top