Forum Discussion
Automatic Data entry manipulation
I have a master sheet of data that my coworkers are using to input data from outreach efforts. It looks similar to the snippet below. This is only an example so I am not sharing confidential informat...
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.
- Thank you for providing the example file. It seems to work well with the example data, however, I have much different production data and have never used Power Query before. It sounds like I need to figure out how to apply power queries to my actual data!
