Sorry for the delay in responding. Unfortunately, I don’t know how many worksheets I need. As a generic example (not the real application), consider a set of customer ledgers in an accounting package. I want to create one worksheet inside the workbook for each customer, showing their debits and credits. The name of the worksheet (appearing in the tab) would be the customer name.
Since the number of customers in this situation is variable, pre-allocating worksheet tabs and splitting them manually as you have in your example won’t work.
What would be perfect is a way to tell YARG that the spreadsheet template I am providing should be “stamped” on multiple worksheets, one for each entity returned in a band. So, it would be a band setting. Along with it would be the field to be used for the worksheet name.
Is this possible?