Hi!
I'm brand new to this forum, but not so new with Excel, except when it comes to Macros and VBA. I run a report once a month that contains about 500 rows of data and I subtotal with the SUBTOTAL button under the DATA tab against a couple of columns. I have tried to split the main worksheet into multiple worksheets based on the subtotal, but when I have copied any code, it doesn't work well with the subtotal row for each unique value in the column. Is there any code, macro, or something else I can use to split this. My goal is to split it, and then save each individual worksheet as a separate PDF file. Right now, I am copying and pasting each group to a new workbook, and then saving that as a PDF. It's very tedious. If this is possible, is it also possible to have a special header for each individual worksheet. I have also attached a file with a master worksheet, and management worksheet. The master worksheet is before I subtotal my data in the management worksheet. Thank You!!Maintenance June 2013.xlsx
Bookmarks