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...
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.