View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dkk dkk is offline
external usenet poster
 
Posts: 8
Default Complicated Lookup Code

At least it is complicated to this novice. I would like to click on a cell &
cursor go to another table. As an example:

Table 1: Click on cell that contains the number 2:
Jones Smith
X 4 5
Y 3 2

And cursor goes to the Time in Table 2 (in my example the cursor would go to
cell that has the time of 1.4:

Time ColumnH ColumnI
1.1 X Jones
1.2 X Smith
1.3 Y Jones
1.4 Y Smith

If I clicked on the number 3 in Table 1 the cursor would go to cell with
1.3, etc.

Any help would be greatly appreciated!!