Hi macropod,
So, is the table you want to get the blue data from always the second table in the document?
Yes.
Also, your tables have multiple rows. Do you want only the second row from each table, or do you want the other rows as well?
Yes only the specific row that I have highlighted using red/blue box.
Finally, your Excel workbook only has one destination cell for each table row, but the tables have three cells per row. Your Excel worksheet should also have 3 cells per table row.
To make things clearer, I think I should have specify how the data should appear in Excel - which I have done now. Please see the attached spreadsheet.
Thanks.
|