Forum Discussion
QZ
2 years agoHelper I
(M code)How to extract multiple sheet data from Excel which in multiple folder by Power Query(noDAX)
The budget Excel file save in folder every month, the folder name named by year and month, for example: 202401, 202402, ......, (refer bellow picture, for the purpose of simplification, only save th...
QZ
2 years agoHelper I
is it possible to inside cell then directly update cell value?
refer bellow pic, cell value is a table, can change value from red rectangular frame to green rectangular frame directly by Power Query?