View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ibo4lyf ibo4lyf is offline
external usenet poster
 
Posts: 6
Default QUERY EXCEL TABLE DATA

I have built a matrix to track data (Worksheet A). I am hyperlinking
individual elements to other worksheets (MULTIPLE, too many, blah). I
have decided to build one worksheet with all the data in a single
table (Worksheet B). I would like to be able to click on a hyperlink
(from Worksheet A) and not only be taken to the next sheet (Worksheet
c) but display only the desired data (from Worksheet B).

Is their a formula to query and display the desired cells?

thanks in advance!!!!1