Link errors in spread sheet to text file

[lweng]

Attached you will find a excel file with a macro that extracts data from a text file and organizes it into a manageable spread sheet (Thanks to JBeaucaire ).

Sometimes this data results in some errors which I addressed with labeling the errors with a red box and an “X” And I have a button that brings the errors to the top.

Here is the question: Can I take those errors and hyperlink or make a button that will take me to those errors in the text file or another tab on the excel book to investigate further.

Thanks in advanced for the help. I attached a shortened version of the text file.

[JBeaucaire]

You can't hyperlink INTO a text file. What is it you are trying to accomplish in the end?

[JBeaucaire]

Hmm, once again I find my code taken and used gratefully, except for one small change...where my name is removed and replaced with someone else's. I didn't realize how offensive my name was to the people I help.

Go figure.

[lweng]

I'm sorry I added a lot of code I didn't know if you would like your name on it or not. I’m not a programmer so it’s messy, I did not know if you wanted to be associated with it or not. I can put your name back on if you give me permission.