Forum Discussion
linking spreadsheets in excel
I am trying to link spreadsheets. I am exporting data from my SIS and have a spreadsheet I need it to update every week.
1 Reply
- If you are wanting to pull in data from a an export every week then using Excel's Power Query is perfect for that.
If you have Excel 2016 or later go to Data > Get Data from Workbook and selected the file and then then sheet you want to pull in and click Edit (or transform) then you can use Power Query to clean up the data and finally go Close and Load to... and load it to a Table in Excel.
