Wondering if anyone has a solution for this.
If I have a template for how journal entries should be set up (attached), is it possible to take that template and create multiple tabs in an excel file that are formatted that way. That way I can use an output data tool within a batch macro and print to the tabs while keeping the formatting the same.
I'm not interested in manually copying and pasting the template. I have the 1 template, and I'd like to automatically create many tabs that are all formatted the same way.
Attached is some sample journal entry data already arranged how it should print into the output file. In the sample data I have 4 tabs: Segment 1 1000, Segment 1 1004, Segment 1 1052, and Segment 2 1000.
I'd like to be able to
1. Take template file and use it to create a new file 'JE' with 4 tabs (listed above) that are formatted how the template is.
2. Print the sample data into the formatted tabs (keeping the existing formatting).
Is this possible?
