Another department sends out enormous status reports in the form of a 20-page
long Word table every week. (7 columns with headers, many rows). I've been
kind of laboriously copying/pasting/reformatting the thing into Excel so that
I can analyze the thing more effectively, but it's always rather painful.
(And there's no way they'll ever just convert the thing to Excel permanently.)

Is there a macro that would copy the contents of each cell from the table in
the Microsoft Word document into an equivalent cell in an Excel template that
I could just empty out and refill every week? Complicating things is the
format the table is in: Whoever puts this thing together insists on merging
all the cells in a row to make intermediate heads that appear throughout the
table.

Thx in advance, everyone!