Forum Discussion
Need help on Excel Script: Show data from a query inside a new sheet
Hi all, I need your help as I cannot record the actions I need to perform to generate script. I have a data query loaded in the excel workbook and I need it to be automatically be put in an exis...
JKPieterse It is working but it doesn't solve my final goal.
It is possible with script to Delete a table then map a new table based on a data connexion?
Please write down all individual steps you require. Our, even better, explain in detail what you are trying to achieve
OK here is what I need to perform:
I have 3 data queries inside a workbook: (sorry screenshot is in french)
From these queries I would like to create a table in A1 on a dedicated sheet (Deviation, CAPA, Other CAPA Plan) after updating the queries. Tables should be named Deviation_Table, CAPA_Table and Other_CAPA_Plan_Table respectively.
I usually create it by hand using Excel desktop application: (Example from Deviation query)
Thank you in advance for your help 🙂
- Are you saying you want to keep a static copy of each table before that table is refreshed?
- Yes right! Actually I need to remove the static copy, refresh data source and then load a new static copy.