Log In
Register
Home
New Member
July 31, 2021
Offline
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]
Active Member
Power Query
February 24, 2021
Offline
Have you tried outputting the summaries to a table? You could then upload that into Power Query and then link via SharePoint.
October 5, 2010
Offline
Hi,
Have you read these posts which cover what you need to do
https://www.myonlinetraininghu.....a-folder
https://www.myonlinetraininghu.....ower-query
https://www.myonlinetraininghu.....ower-query
Regards
Phil
New Member
July 31, 2021
Offline
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
1 Guest(s)
