Discussion on:

Add data to an Excel worksheet from a Word table

That's a cool set of steps, but it seems to be a few more than I go through to move data.

I'll select and copy the table in Word, paste it into Excel, Then clear all the formats by applying the Normal cell style to it.

The more steps, the easier it is to muck it up, I've found.

Haha, I was about to say that!

You even don't have to apply formats if you use "Paste Special" when pasting your data. So you can do the whole task by simply Copy + Paste Special

I don't think the point of this exercise was necessarily just to import a table from word to excel, that in and of itself is rather simple, but rather the author is trying in a clever way to teach people about the import text wizard and how it can import and parse a delimited text file of any size.

TO MANY STEPS. BEST IS TO COPY AND PASTE

Wow, what a complicated way to copy and paste special !
Nice try though, better luck next time

ya Too many steps, but for bulk data usefull

There's no more to say than...Ditto to all previous posts.

kinda counter intuitive when c&p'ing has worked just fine

how about up-dating a an excel table in a word doc from a main excel sheet automatically when the word doc opens....

I agree with everyone about the value of copying and pasting -- I do it all the time.

But down near the bottom, the author just casually throws in using Excel's Data > Refresh function. IMHO, that's big.

Say you bring in a table and do some formulas, If you copy-and-paste again when someone sends you the update, per the author's example, the links in the formulas might disconnect, especially with a shared workbook (don't flame me, I'm only posing a hypothetical).

My initial reaction is the same as everyone elses; copy paste does the same thing and is much simpler.

However, I can't help but wonder if there is some specific thing we are all missing here. Is this something that provides a benefit over copy and paste in some specific case?

Can you give an example scenario where this would be prefered over copy and paste as well as an explanation why?

You need to better explain what is done within WORD, before switching over to Excel. You also need to better separate the differing functions/steps that are required to be actioned in Excel 2003/older, as opposed to Excel 2007.

can this work the other way around? WORD > EXCEL?

the import from my form according the directions has to be converted back to text from table and then saved as text file and then imported to excel. the problem is that that the data is pulling the headers of my chart down the spreadsheet instead of accross. I'm sooooo frustrated.