Forum Discussion
Dynamically change a table size to match the size of another table?
Hi, I am trying to design an Excel solution with 3 worksheets. All Worksheets are formatted as Tables. Worksheet #1 gets data from a SQL Server so number of rows changes constantly. Worksheet #2 and...
Perhaps you may shift on Power Query to import data from SQL server and transform them into another two tables. When everything will be updated with each refresh.
SergeiBaklan I could bring in the data via Power Query, but how does it help with those other two tables in Excel? They still need to be worksheets. Can you please elaborate?
If we speak about Excel Tables that doesn't matter where do you place them - in same or separate worksheets. Having one query which takes data from SQL, based on it you may generate couple of more queries (or more taking into account other supporting queries), each of them transforms data receiving by first query and lands result into the separate table. Something like this.
