| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I print multiple print areas on one page | Excel Discussion (Misc queries) | |||
| Can I adjust print scaling for multiple print areas on the same sh | Excel Discussion (Misc queries) | |||
| How do I set print areas for multiple sheets simultaneously? | Excel Discussion (Misc queries) | |||
| Multiple Print areas in same sheet? | Excel Discussion (Misc queries) | |||
| Set Multiple Print Areas | Excel Discussion (Misc queries) | |||
Linear Mode
