Is there a way to allow data typed into a microsoft excel sheet to be auto transferrred into a word document?

Question

If there is any programming to be done, please provide some codes. I am hopelessly lost here!!
Once I select the data (by ticking it in excel) The selected information should be transferred into the word document.

No cutting and pasting should be required.

Answer 1

Correct me if I'm wrong: You want to embed data from an excel spreadsheet on a word document, so that the updated information is automatically updated on the word document? I'll have to poke around to see if I can figure out how to do what you're trying to do...

GOT IT!!
In Word, select Insert--> Object. Select the tab that says "Create from file". Select "Browse..." & find the Excel spreadsheet you want to embed. Then click the "Link to File" checkbox, click "OK" and you're done. All changes in the spreadsheet will update instantaneously in Word.

Answer 2

Sure! its very easy. Just highlight what you want to copy (all of your cells with data), and select "copy" from your main menu (Edit > Copy). Then go to your Word document, and where ever your cursor it (the location where you want to transfer the excel data), just go and select "paste" from your main menu (Edit >Paste) and it should appear in the document.

There is no way that I know of to "automatically" transfer the data to Word. It's just as easy to Copy and Paste.

Answer 3

Try using the built in Office Assistant in MS Office for assistance.