First, some background:
My company has recently transitioned into using a new accounting software that we are having some troubles adjusting to. The check registers (a detailed report about how much is owed to different vendors and what check it is to be assigned to) that the new software runs are not formatted well when printed. You can export the reports as an excel file, but they are formatted poorly and contain a bunch of useless information. I created a new file that you can copy and a paste the contents from the exported excel file and a macro will format it in a more desirable way. All the information (including the subtotal) is just copied values and no formulas are involved. The check report will vary in the number of line items and different vendors day by day, which creates a challenge when creating the macro.
The issue: I have been asked to create a page break so that the data for each check is printed on a separate page (i.e. after each subtotal). I tried messing around with the "Subtotal" tool under the "Data" tab to create a page break after each subtotal hoping I could just record it and add it on to the existing Macro, but it just created a mess because of the way I had to format the new check register based on how it is originally printed. I was wondering if you all could offer any solutions for being able to create that page break after each subtotal with a repeated heading (lines 1-4) at the top that would work for this specific format of a table. I have included pictures of an example of the check register report after being formatted by the macro. Numbers and account names have been changed drastically for privacy.
If more information is needed, just ask and I will reply. Thank you!
Bookmarks