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

Reply via email to