I would like to create an excel file that would use an odbc connection to a
database, using microsoft query and return a summarized report. Then i would
like it to be able to give me the break down, on double clicking a certain
cell of that summary in a new workbook and run a similar sql query to return
the data for that cell only, using say i clicked on f20, to use a20, b20 and
c20 as inputs for the new query as a pin point query detail.

Any assistance would be appreciated greatly. No matter how small, just even
opening a new workbook from double clicking on a existing workbook cell that
has a query behind it.

Thanx in advance.