Can Excel use its data to export specific cells to Word?

Question

I have a payroll worksheet in which you enter hours/hourly rate and it calculates taxes and net pay. Can I use excel to take that info calculated and export it to a word doc.? Sort of a "pay stub" document?

Answer 1

There is a fun way to do what you want.

First set up your Word document the way you want it, but leave spaces for the data. Set up your Titles like Employee Name, Gross Pay, Year to date, Federal, Fica, etc.

Then when you have the titles you want and you are ready for the data, open your Excel sheet with some numbers in it ready to go and here's what you do:

Select a number you want linked by clicking on the cell. Carefully place your cursor point on the darkened selection border, use the right mouse button and click and drag it into Word to the space you want it. A menu will come up and you select, "Link Excel Object Here."

Once you have all your objects linked to the correct places, then you can go change the numbers in Excel and what is in Word will change along with it.

If you have problems with the updating of the numbers, you can go into Word and do this: Edit, Links, Update Now.

Another way is to design your Pay stub on a new worksheet (Insert Worksheet) in Excel. Link the cells and print it from Excel. You use Copy, Move to the other worksheet, Select the cell, Paste Special, Paste Link -- inside Excel.

Have a ball! Linking is very powerful.

Answer 2

Copy the cells you want from Excel. In the Word edit menu, select "paste special" and then choose "paste link" and the formatting you want. Your Word doc will update from the spreadsheet whenever it's opened, and will ask you if you want to update before printing. You can also force an update from "links" on the edit menu.

Excel doesn't export the data in the sense of pushing it into the Word doc; Word pulls the data out of the saved version of the Excel file

Answer 3

Well, if I understood what you mean, then here is a way to do that:

just highlight the cells you want exported, right click on them and choose copy. Then paste into an open word document by right clicking there and choosing paste.