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 and match formula to look up the information I needed all of this works great.
The big problem is I want a blank column that the end user can edit and add notes related to each row in the table. When I refresh or sort they disappear or move around the sheet, even though it is a table ??? Please help !!!
Here are some of the references that I have tried and none have been successful. Using Excel 2016
New rows do get added to my table upon refresh and information is always changing the columns
https://exceleratorbi.com.au/self-referencing-tables-power-query/ Self-Referencing table to make editable column
https://www.youtube.com/watch?v=duNYHfvP_8U&feature=youtu.be
https://social.technet.microsoft.com/Forums/en-US/e1c18dfc-fff2-4621-96a6-bd1a7a3903f4/how-can-i-add...
