Hi MyOnlineTrainingHub,
I have question about POWER QUERY. I have Multiple Excel Files having same sheet format, but different data. And I only want summarize to 1 excel file.
But I only want get data from specific cell of Excel Files (for example only cell F6, I3, K7, not all column data).
And when I copy more Excel Files to this folder, and only change the cell value F6, I3, K7, the sumarize file is updated.
Can you help me?
[Image Can Not Be Found]
[Image Can Not Be Found]
[Image Can Not Be Found]
Have you tried outputting the summaries to a table? You could then upload that into Power Query and then link via SharePoint.
Hi,
Have you read these posts which cover what you need to do
https://www.myonlinetraininghub.com/power-query-get-files-from-a-folder
https://www.myonlinetraininghub.com/combine-excel-worksheets-with-power-query
Regards
Phil
Thank for your reply
Actually I only want get data from specific cell of Excel Files (for example only cell F6, I3, K7, not all column data or table).
It means that in each Excel File, I only get 3 cell data, and automatic update in summarize file.
Regards,
Nguyen
I think you'd be better off with VBA for something like that.
Hi
I suggest to use the Indirect formula
This formula can capture the cell values from diferent sheets or books
