Creating Index

[Doug]

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.

 

[Charlie]

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