Extracting Innertext Values of TD by Finding Common Word

Greetings!

I am currently working in an automation that will extract values of innertext with common word from all rows. Example is the word "DOWN" is common to all table and I want to extract all the values of the row with the word "DOWN" and extract it to the excel sheet. can you help me by making a vba code that will look up for the word "DOWN" in webpage and then will copy the innertext values before and after the said common word.

see the screenshot for the idea.
nagios.jpg

here is the html codes for the said table.

Please Login or Register  to view this content.

I want to extract all rows that has the word "DOWN" and then put it in an excel sheet.

I think maybe this code is suitable for extraction, I just don't know how to revise it to match the requirements.

Please Login or Register  to view this content.

since the table is changing regularly, setting a definite number of this code is not applicable, we just have to provide a code that will extract ALL rows with the word "DOWN", hope you get my idea.

the code will run
the code will find the word "DOWN" in td elements
the code will extract the other values in the row where the word "DOWN" is, [e.g. 191_sector_3, DOWN, 03-27-2012 16:20:42, 2d 6h 4m 47s, (Host Check Timed Out) ]
the code will put the extracted values to the sheet
the code will run again to find another row containing the word "DOWN"
the code will extract again the values in the row
the code will run until the last row containing "DOWN" is extracted.

http://img821.imageshack.us/img821/3223/nagios.jpg

here is the workbook, example is a sheet I wanted to become, the values will be extracted in this manner.

AP Alarms.xlsx

bump no response

yes nilem, the idea is correct, but I will be extracting the data directly from the webpage, as given with html codes.