Linking 2 workbooks

[Iywilson001]

I would like to create a dashboard. The raw data will come from a generated workbook that I will download from a system daily. I would like the dashboard spreadsheet to update as the raw data changes daily. How do I like the dashboard workbook the daily downloaded workbook? Basically I want the raw data to feed into the dashboard workbook to produce visually pleasing data.

 

[Sufiyan97]

You can do it with Power Query

have a look at

Combine Data from Multiple Workbooks in Excel (using Power Query)

Power Query can be of great help when you want to combine data from multiple workbooks into one single worksheet. Here is a step-by-step guide on how to do this in Excel. You can combine data when it's stored in an Excel table, or even when it's not formatted as a table.

trumpexcel.com