Help using variables with Hyperlink
 

Someone please help me before I beat my brains out. I have struggled with
this for HOURS, reading help files, this forum, and just hacking variations
but it still doesn't work!! Wish I wasn't such a noOb. My situation:

Worksheet "customers" has two sheets. In column A of sheet one, I have a
list of names where the occasional entry has the word "total" in it. I have
written a macro to find these entries. Once found, I want to create a
hyperlink to that found cell in column A of sheet two.

So, on sheet one, if row 5 contains "XYZ Total" and 7, "ABC Total", sheet
two should contain a hyperlink in A1 that displays "XYZ Total" and links to
the entry on sheet one. and A2 should have the link to "ABC Total". Of
course, I don't know what cells contain "total" on sheet one until my search
macro finds them. My variables track the cell in which "total" was found and
I guess the next available row for the hyperlink. You name them what you
want.

Please help me. Please! <sobs