Excel Question

[nickerjones]

There is probably some really easy answer to this but Im glossing over it. I have googled and not seen anything. I have a workbook with about 50 sheet tabs. Is there an easy/simple way to embed or show these on a word document? Do I have to go through and copy each tab and paste it?

[bluejays]

No idea. If it were a formula, I'd be able to help, but this is a weird one. What about converting to PDF?

[nickerjones]

Originally Posted by fleury

No idea. If it were a formula, I'd be able to help, but this is a weird one. What about converting to PDF?

Nope what it is , is a different city on each tab with their population demographics. I want to put all the tabs into the word document.

[Drury18]

Far as I know, there is no easy answer and you have to paste each sheet (or import it) into Word. The import functions only pick up on the active worksheet, not the entire workbook.

The quickest way I could think of is that if you are finished with all edits, print your entire Excel workbook as a .pdf. Then open the .pdf in Acrobat (not reader) and save as a .doc file.

[oilyfan]

Only way I know is through macro programming...

[Hanni]

Is there a reason you have to put it all in a Word Document? The simpler solution might be doing what you want Word to do in Excel instead of the other way around.

[Rathji]

You could use the data in each sheet to populate a table in word, but that is likely going to be a lot of work since I am pretty sure you can't do it all at once.

[nickerjones]

Originally Posted by Hanni

Is there a reason you have to put it all in a Word Document? The simpler solution might be doing what you want Word to do in Excel instead of the other way around.

Yeah it's some demographic and financial data for about 50 cities in a state. I had to pull them off the census bureaus website in excel. I have to put the info in a word doc.

[Flames89]

You could link each page in word to an excel table, but that won't save you any time unless you foresee the data in the table changing and you don't want to have to redo the copy/paste

[Wormius]

Is there a lot of data in each sheet? Is it a possibility to create a main sheet and pull all of the sheets into that and then format with page breaks, etc? Then just import that into Word.

[Ozy_Flame]

Your best bet may be to convert the Excel data to a MySQL database or something, and then have a Word document pull the SQL data into a Word file.

But that will require a good understanding of SQL/code to put together.

Are you sure this link wouldn't work?

http://www.makeuseof.com/tag/integra...word-document/