Export Querys to Multiple Excel Worksheets

[Marleyuk]

Hello, i have a database that imports data then run queries on it on the fly. This is all as an onclick event. I also want to export the query results in the same event. I have a spreadsheet template and i want to export the results for each set of query results to a formatted excel worksheet.

I am running 7 querys on a dynamic amount of columns.

Does anyone know how to do this?

 

[JerryKlmns]

If you export query QWERTY to an excel file containing an empty already formated sheet named QWERTY then your exported data is alread formated in the excel!
If you have one only template, create a copy of that and use the copy. Use automation to rename the sheet name to match each query name.