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
|