I have multiple SQL stored procedures that provide both subtotal and summary information. Goal is have all the stored procedure result sets writing to the same Excel worksheet in specified locations. The nearest I've gotten is correct locations but SEPARATE worksheets of the same Excel spreadsheet. Close, but that means I have the same problem I started with, having to copy/paste data to get the correctly formatted results. Is this possible?
