It depends on how often you need to perform this task if it is worth writing
a macro. You can open a word application from excel VBA. Then you can find
each table in the word document and copy all the data from each table into
excel. It get more complicated if you want to only copy some of the rows
from some of the tables.

You can same the word document as text files and then have excel open the
text files and read the data. Again it depends how much of the text you need
to read in excel how complicated the macro is going to be.

"NSNR" wrote:

Hi
I have some data entered in MS word (Office XP) in tabular form(formatted
data) using tables. This data have to be copied in MS excel worksheet and
then sorted based on few columns. Can anyone suggest methods to do this.

Since copying/pasting each row of a table in MS word on to a row in MS excel
is time consuming.

--
reply to my posts are welcome