Create a Summary page to a multi-worksheet report using Excel's INDIRECT. (Part 2)
In Part 1, we show you how to use Jet Report's NL(sheets) to dynamically generate multiple worksheets. While this is useful, the challenge is you may not always generate the same number of sheets and/or the sheets are not always same the same number of lines. Or, maybe you always have the same number of worksheets in the exact same format. Regardless, now it's time to summarize those worksheets!
You can use Jet Reports to bring in the summary details but if this is a multi-company report, the report performance can be slow.
Let's use Excel's INDIRECT function instead!