Excel Report Reduction - Is this possible?

The_Hurricane

Hi All,

I have four separate spreadsheets with one table in each and vast amounts of other data. At present the four tables are manually copied onto a Word document used for presentation.

Is it possible at all

1. To have the four spreadsheet tables feed onto two tabs within a new spreadsheet.

2. To PDF and Hyperlink the spreadsheet so that it pulls the existing report headings from the Word Document?

Thanks in advance

paddyrg

Yes it is, however each stage becomes a bit more delicate as if you move a file/rename a folder/anything fancy. With trying to get too fancy 'pdf and hyperlink headings' I suspect you'll make something quite frail/dependant on external factors. There are almost certainly easier ways to achieve the result you're after, such as print ranges within excel, maybe>

aldredd

Not sure about having a live PDF file, but you can have a live Word file linked to your Excel files, which you can then PDF as-required.

Based on Office 2010...

• Open Word File
• Open Excel File 1
• Copy your excel range you want to see in Word
• Switch to Word
• Paste you data
• In the bottom right of your pasted table, you should see a little box saying '(CTRL)' - click it
• You should get a row of little icons - hovering over each will tell you what it does. There will be one named 'Link & Keep Source Formatting' or 'Link & Use Destination Styles'. Selecting either of these will link your Word file to your Excel file.
• When you change your Excel file, return to the Word file, right click on your Table and select 'Update Lnk'
• Repeat for other Excel files
• Save as PDF (Save-As, Save-as Type = PDF)