Forum Discussion
import data from a master file in to other excel files
Hi, i have a master file that i fill in daily with new data that has 5 different business accounts (column k e.g xtr-, bms- etcetera). This file produces a kpi for what's outstanding. New data is add...
You could create 5 power queries within your master workbook, and then use those resulting tables as the source for a power query into the five other workbooks. The files could be set to autorefresh their queries, so the latest data will always be available.
(You could also go directly from your master tables into the five other workbooks, but that would allow a savvy user to edit the query and possible get more information than you want to allow.)