Hi,
Thanks for getting back to me.
I want to use the data to populate some excel tables I've designed.
I'm sure I can design the template to pick up data from a hidden sheet.
I want the report to populate the hidden sheet and therefore populate the analysis tables on the next sheet.
Does that make sense?