Forum Discussion
John_Maron
May 12, 2023Copper Contributor
Excel dunce! Please help! Don't even know what I'm trying to do is called!
I have a very basic understanding of Excel and need an answer to a question in the clearest terms possible. Step-by-step if possible. Or at least direction in what the function I am trying to accompl...
OliverScheurich
May 12, 2023Gold Contributor
You can try Power Query aka Get and Transform. 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.
John_Maron
May 12, 2023Copper Contributor
Thank you. I will try that.