Jon_London
New Member
- Joined
- Jan 24, 2019
- Messages
- 12
- Office Version
- 365
Hi there everyone
I have a spreadsheet that has each month of the year as a column and each of our products as a row.
I need to use SQL data queries to pull through the total amount of sales per product each month. I have the SQL script for each month/product, but I'm unsure of the best way to pull this into Excel using a Data Connection.
An example of my spreadsheet is shown below (shown as a table here). So, I would want to pull down data for e.g. Product1 for Jan, Product2 for Jan and so on. My method of creating a query for each and then "Loading" the output of the query into the relevant cell as a table, then removing the table header, seems very long winded. I'm sure there must be an easier way!
Any help would be much appreciated.
Many thanks
Jon
<tbody>
</tbody>
I have a spreadsheet that has each month of the year as a column and each of our products as a row.
I need to use SQL data queries to pull through the total amount of sales per product each month. I have the SQL script for each month/product, but I'm unsure of the best way to pull this into Excel using a Data Connection.
An example of my spreadsheet is shown below (shown as a table here). So, I would want to pull down data for e.g. Product1 for Jan, Product2 for Jan and so on. My method of creating a query for each and then "Loading" the output of the query into the relevant cell as a table, then removing the table header, seems very long winded. I'm sure there must be an easier way!
Any help would be much appreciated.
Many thanks
Jon
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | etc... | ||
Product1 | |||||||||||
Product2 | |||||||||||
Product3 | |||||||||||
Product4 |
<tbody>
</tbody>