I see from your speadsheet you want the data from two tables. You did not say that before. So, is the table you want to get the blue data from always the second table in the document?
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?
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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|