Forum Discussion
venkatvedavyasan
Apr 03, 2023Copper Contributor
Stationary Provisioning based on month
Hi, I'm trying to prepare a inventory which is quite big of which I have given a sample below. I have a data month wise where it says what item is provided to the department on which month ...
OliverScheurich
Apr 03, 2023Gold Contributor
You can try Power Query. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.
The data layout in the screenshot and in the attached file is for illustration. You can place the green result table to the right of the blue table or in another worksheet.