How to make EXCEL file of Cost Report into a printable file like PDF?

[LSD]

how do you guys deal with this work?

I can just make every EXCEL to a PDF and merge them together. But it cost a lot of time. Do you have any good way?

[AndreasK]

Hi LSD,

on Windows with Adobe Acrobat Pro you can mark as many pdf-files as you want and merge them all at once. (Right click -> merge)
If you don't have Acrobat Pro there are several freeware-tools that can do the same. Propably easy to find via google.

[Francis Gagné]

If your familiar a bit with VBA You can write a macro to save all excel files in a folder to PDF.

Here's a sample script : http://stackoverflow.com/quest...2010-to-pdf-using-vb (http://stackoverflow.com/questions/11209960/excel-2010-to-pdf-using-vb)