Multiple print areas, one worksheet -need to print to PDF!
 

I really need help. I have an excel spread sheet. Each column (C-Z
represents a client. I copy the columns one at a time to column to B.
Coulumn B is linked to my print areas.

Here's the problem: I have two print areas in one worksheet. I nee
each report for each client printed to a PDF. I already have a macr
that does the copy-paste-set print area-print, but when I set m
default printer to PDF and run the macro, each report overwrites th
previous one. Therefore, I have to manually copy-paste-set prin
area-save as file in order to get a PDF.

I am working in a MAC and will soon be smoving to a PC. I was able t
print a batch set to PDF in OS 9.2, but now that I am in OS X, I can'
figure it out. All help and suggestions are welcomed

--
mohagany1
-----------------------------------------------------------------------
mohagany19's Profile: http://www.excelforum.com/member.php...fo&userid=1324
View this thread: http://www.excelforum.com/showthread.php?threadid=26707