Hello, I have a spreadsheet as shown below:
Name ID Start Date Company John A 101 1/1/2010 A Vicky T 115 1/8/2009 A Tim H 112 6/1/2009 B Mike B 113 7/1/2010 C What I want to do is automatically create a pdf file for each company with company name as the file name. In the abolve scenario, I should have 3 pdf files. My actual table is 7000 rows with almost 100 different companies.I currently have to manually convert each company from Excel to pdf by doing save as, but it takes forever. Is it possible to do this one shot? Also, I would like to have page # for each page out of total page # for that company. I also have a disclaimer at the footer and my business logo at the header that I want to include in each page. Is it possible? thanks! -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe