QUERY EXCEL TABLE DATA

  • Thread starter Thread starter ibo4lyf
  • Start date Start date
I

ibo4lyf

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
 
You can use Microsoft query to extract from Excel files - just make
sure your queried file is in database format - all columns contain the
same data types, no completely empty columns or rows etc. Data -
Import External Data - New Database Query. Choose Excel Files* for the
Data Source and navigate to the workbook and sheet you want to query.

You may also want to use the Worksheet_FollowHyperlink event to either
trip/display the desired query or just filter the sheet being linked
to so the info you want is displayed.

Cliff Edwards
 
You must log in or register to reply here.

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

Excel 2013 Merge Data 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
MS Excel VBA Pivot table link cell fetch records 1
Assigning a worksheet name to a variable 3
Ron de Bruin - Merge cells from all worksheets 0
MS Excel VBA Copy and Paste from external workbook data to central worksheet 1
Error Message - Macro to Unlink MS Queries from Workbook 0
Problem with a macro 1

Back
Top