Find Fail And Place Link Same Row In Column 1

[ajocius]

I have a sample file with data which has test failures. I would like to find the last incident of a failure denoted by the word in a cell labeled Failed. A row may contain multiple Failed results but the last one reading from left to right in the cell which is most important. I would like to copy a link from the last cell in that row with the "Failed" and copy a link into the first column of that row. Note only rows which have a Failed in column Z need be checked. Note, cell A10 has a sample of what I would like as the end state. Those rows with a cell in column Z which do not have the word Failed, that row can be ignored. However, if a "Failed" is found in column Z the entire row must be searched for the last "Failed". Finally, I request this all be done in VBA with nearly unlimited rows and columns which can go past 3000 columns.

Tony

[Keebellah]

It's possible.
Just a question,. the word Failed in Z is this your manual action?
If can be added with a formula.
What do you mean with 'copy a link from that cell...' ?

[Keebellah]

I got that too, you want a hyperlink to that cell if the count of Failed is >0 and the the last cell in that row with failed.
First you always count from last to first in a loop makes it 'faster'
I'll see if I van do it for you.

[Keebellah]

Try this
Press the green image to run the macro, the statusbar shows the progress

[ajocius]

This is very close. It doesn't work as downloaded. I can see the progress status change, but the links aren't added to col A. I also noticed the lstRow variable has SpecialCells(xlCellTypeLastCell).column. Almost there.....thanks.

[Keebellah]

No problem here, after the macro has run and I click the Failed in Column A it takes me to the last cells in that row where the text reads Failed.

[Keebellah]

Okay, I am reading from right to left, well, just turn the loop around instead of lstrow to 2 step -01 2 to lstrow
A little logic of your own ...