Sorry to be a pain, i know its more than likely a simple answer but i cant
work it out on my own.

i have a file with a bunch of worksheets on it and one summary page on the
front with all of the totals on it. I also have a seperate file (excel) that
has all of my repairs on it. So basically when the boss says why did we spend
so much on machine x, on the totals page, i want him to be able to click on a
link or something like that, that will take him to the other file with all
the repairs listed on it.

Thanks For Your Help