I have a report that I need to update it on weekly basis. The report contains the raw data and bunch of Tables (Sumifs) and Pivot ones that are being fed by raw data. The current process is to extract data from SQL server and copy records to raw data tab, expand the fields (Months and formulas) to capture current month data. I like to be able to automate the process as much as possible. I did try using MS SQL Query in Excel with no avail and was a pain. I am using Excel 2010 and the SQL backend version is 2008R2. I appreciate any suggestions to help automate this process.

Thank You,

Helal