Forum Discussion
Add a column to a Query that the end user can edit and is linked to that row information
I have a dynamic worksheet that I have taken from our internal data base. Then I have pulled a power query to bring all the new file numbers as they get added. Then built out each column using index ...
That trick is definitely works, it is 5-years old on was tested quite many times on different files, Key point you have to have unique ID for the data.