You can copy the columns in the table, paste the rows on a new sheet and set the new sheet to recalculate. It can be done without VBA code. This tutorial is a small tip that you may find useful while working with multiple tables in a document. More items How to Extract Data from Word Table Entries — How To Copy Table Entries & Calculate Values Using VBA This tutorial shows you how to extract data from Word Table Entries and calculate values using VBA. The technique uses a very How to Extract Data From Word Table Entries — VBA Code for Excel This video explains how to extract data from Word Table Entries. It covers the technique that was used by Chris Raise's book “Word and Excel with VBA.” Also shown is the spreadsheet that the data is extracted using a macro. More items Copy & Paste Multiple Excel Tables Into Microsoft Word With Power Query How to copy multiple excel tables from word to excel with power query. How to Copy Data from Word Tables into Excel Excel data source code example. You can use this technique in conjunction with VBA macros to extract data easily from word tables. How to Extract Excel Data Using VBA — Using macros to extract data from excel The data is extracted by using a macro. So it is very useful to make this code in VBA macros. More items How to Extract Multiple Excel Tables From Word to Excel With VBA with Step-by-Step Process This tutorial explains how you can extract data from a text and then copy and paste into Excel with this tutorial. With this VBA code, the Excel file would be copied. It is very useful for data extraction and is a powerful data extraction technique. The tutorial shows you how to extract data from Word files, tables and columns. It uses the text of the Excel file from the previous tutorial as a data source to extract data. Also included, is the spreadsheet that the data is extracted using a VBA macro to calculate values. To extract data from Excel, the Excel file must be a text file. More items How to Excel Table Data Into Excel with Power Query This video shows you how to extract the information from a text data table into Excel. Also shown is the sheet that it is done on. It is great that they are showing you how to Excel Tables! This tutorial uses the technique that Chris Raise's book uses.