I have the following worksheet:
I would like to save a pdf report of each section using the values in column A to name the files and place them in a folder named using the value in D9. (in this example, I would have reports named 005.pdf, 010.pdf and 011.pdf and would be contained in a folder named 040407-071707)
Sample: Rows 1 through 15 should be at the top of each report, rows 16 through 23 should be the first report, rows 26 through 33 should be on the second report, rows 36 through 41 should be on the third report, etc... (row count may vary between each report)
I'm fairly proficient with vba, but need some help getting this one figured out.
Thanks in advance...
| Excel Workbook | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | H | I | K | L | |||
| 1 | ||||||||||
| 2 | ACME HEALTH CARE FACILITIES | |||||||||
| 3 | PAYROLL VARIANCE REPORT | |||||||||
| 4 | April 23, 2007 | |||||||||
| 5 | ||||||||||
| 6 | ||||||||||
| 7 | ||||||||||
| 8 | CURRENT PAY PERIOD | |||||||||
| 9 | PAYROLL PERIODS | 4/4/07-4/17/07 | ||||||||
| 10 | ||||||||||
| 11 | ACTUAL | ACTUAL | ||||||||
| 12 | ACCOUNT | DOLLARS | HOURS | BUDGETED | BUDGETED | |||||
| 13 | DESCRIPTION | # | PAID | PAID | DOLLARS | HOURS | ||||
| 14 | ||||||||||
| 15 | ||||||||||
| 16 | 005 | Administration | Chief Executive Director | 600.0010 | $3,718 | 48 | $6,242 | 80 | ||
| 17 | Chief Financial Officer | 600.0030 | $4,283 | 72 | $4,790 | 80 | ||||
| 18 | Adm. Assistant | 600.0680 | $1,677 | 80 | $1,678 | 80 | ||||
| 19 | Adm. Assistant | 600.0690 | $1,405 | 75 | $1,497 | 80 | ||||
| 20 | Funeral Leave-Nonunion | 600.1311 | $0 | 0 | $0 | 0 | ||||
| 21 | Plt-N-Termination | 600.1321 | $0 | 0 | $0 | 0 | ||||
| 22 | ||||||||||
| 23 | TOTAL | $11,082 | 275 | $14,206 | 320 | |||||
| 24 | ||||||||||
| 25 | ||||||||||
| 26 | 010 | Transportation | Coordinator | 600.0720 | $0 | 0 | $906 | 40 | ||
| 27 | Bus Driver/Trans Work | 600.0800 | $4,920 | 375 | $4,226 | 344 | ||||
| 28 | Funeral Leave-Nonunion | 600.1311 | $0 | 0 | $0 | 0 | ||||
| 29 | Funeral Leave-Union | 600.1312 | $0 | 0 | $0 | 0 | ||||
| 30 | Plt-N-Termination | 600.1321 | $0 | 0 | $0 | 0 | ||||
| 31 | Plt-U-Termination | 600.1322 | $0 | 0 | $0 | 0 | ||||
| 32 | ||||||||||
| 33 | TOTAL | $6,142 | 453 | $5,440 | 408 | |||||
| 34 | ||||||||||
| 35 | ||||||||||
| 36 | 011 | Inhouse Transportation | Coordinator | 600.0720 | $0 | 0 | $906 | 40 | ||
| 37 | Bus Driver/Trans Work | 600.0800 | $1,299 | 113 | $1,880 | 153 | ||||
| 38 | Plt-N-Termination | 600.1321 | $0 | 0 | $0 | 0 | ||||
| 39 | Plt-U-Termination | 600.1322 | $0 | 0 | $0 | 0 | ||||
| 40 | ||||||||||
| 41 | TOTAL | $1,684 | 135 | $2,786 | 193 | |||||
Sheet1 | ||||||||||
I would like to save a pdf report of each section using the values in column A to name the files and place them in a folder named using the value in D9. (in this example, I would have reports named 005.pdf, 010.pdf and 011.pdf and would be contained in a folder named 040407-071707)
Sample: Rows 1 through 15 should be at the top of each report, rows 16 through 23 should be the first report, rows 26 through 33 should be on the second report, rows 36 through 41 should be on the third report, etc... (row count may vary between each report)
I'm fairly proficient with vba, but need some help getting this one figured out.
Thanks in advance...
