My mistake, you are correct, it does work in that sampling, however, when i apply it to the entire report it doesnt work properly. Attached is a larger sampling. For example, click on detail next to column D value "WOMENSSANDALBACKUP". It hyperlinks you to AM03172012C on the other worksheet.

Also, is there a way to click on the value in column D as the hyperlink, ie. click "WOMENSSANDALBACKUP" instead of the word "detail" next to it. Not a big deal, but would just make the report more attractive if it didnt repeat detail over and over.

Thanks again for all of your help.