Hi!

I have tried a number of different ways to solve this but not yet been successful:

I have a Word document containing some text and a table and would like to link the table into Excel, meaning that when the Word document changes the linked table in Excel changes as well. This is is not a problem using the "Paste Special" function in Excel, but my problem is that the table then is not sortable. The alternative is to build a macro or VBA that copies the specific table everytime the Excel sheet is opened, and then pastes it into the Excel sheet, but then the problem comes to identifying the specific table and copying each line from the Word Table to the Excel document.
I would be greatful for any tip! I think this must be a rather common problem.