Print multiple worksheets into separate pdfs

[jmilazzo]

I have an excel workbooks with multiple tabs (worksheets). Each
worksheet must be converted to a singular pdf file with a specific
name. Is there away to do this in a quick way without printing each
worksheet separately?

Thanks
Jessie

 

[jgrob3]

I have an excel workbooks with multiple tabs (worksheets). Each
worksheet must be converted to a singular pdf file with a specific
name. Is there away to do this in a quick way without printing each
worksheet separately?

Thanks
Jessie

Jessie,

Your PDF writer may allow you to put separate sheets to separate files
eg the free www.cutepdf.com PDF writer does this by default.

You'd then just group all your sheets together, then print selected
sheets to PDF and it'll ask you for a filename for each sheet (file)
created.

Regards

Jeff