Creating Index
 

I have an Excel file as a job list containing job numbers, addresses, etc. I
have many Excel files as individual job budgets. I would like to set up the
job list so when I click or double click on a job number cell, it will open
the corresponding job budget file. Any ideas? Thanks.

Creating Index
 

You could right-click on a job number cell and select "Hyperlink" to link the
cell to the desired job budget workbook.

"Doug" wrote:

I have an Excel file as a job list containing job numbers, addresses, etc. I
have many Excel files as individual job budgets. I would like to set up the
job list so when I click or double click on a job number cell, it will open
the corresponding job budget file. Any ideas? Thanks.