Add a column to a Query that the end user can edit and is linked to that row information

%3CLINGO-SUB%20id%3D%22lingo-sub-2162778%22%20slang%3D%22en-US%22%3EAdd%20a%20column%20to%20a%20Query%20that%20the%20end%20user%20can%20edit%20and%20is%20linked%20to%20that%20row%20information%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2162778%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20dynamic%20worksheet%20that%20I%20have%20taken%20from%20our%20internal%20data%20base.%20Then%20I%20have%20pulled%20a%20power%20query%20to%20bring%20all%20the%20new%20file%20numbers%20as%20they%20get%20added.%20Then%20built%20out%20each%20column%20using%20index%20and%20match%20formula%20to%20look%20up%20the%20information%20I%20needed%26nbsp%3B%20all%20of%20this%20works%20great.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20big%20problem%20is%20I%20want%20a%20blank%20column%20that%20the%20end%20user%20can%20edit%20and%20add%20notes%20related%20to%20each%20row%20in%20the%20table.%20When%20I%20refresh%20or%20sort%20they%20disappear%20or%20move%20around%20the%20sheet%2C%20even%20though%20it%20is%20a%20table%20%3F%3F%3F%20Please%20help%20!!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20are%20some%20of%20the%20references%20that%20I%20have%20tried%20and%20none%20have%20been%20successful.%20Using%20Excel%202016%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENew%20rows%20do%20get%20added%20to%20my%20table%20upon%20refresh%20and%20information%20is%20always%20changing%20the%20columns%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcan01.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fexceleratorbi.com.au%252Fself-referencing-tables-power-query%252F%26amp%3Bdata%3D04%257C01%257CNathasha.Nickerson%2540gov.ab.ca%257Ce837d5f4bfc34101599208d8d89bb34c%257C2bb51c06af9b42c58bf53c3b7b10850b%257C0%257C0%257C637497511929130154%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C3000%26amp%3Bsdata%3D8YDEvstrIgaUUMhDxpw46a9StT2aWBdY1RCP14fekcA%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fexceleratorbi.com.au%2Fself-referencing-tables-power-query%2F%3C%2FA%3E%20Self-Referencing%20table%20to%20make%20editable%20column%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcan01.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fwww.youtube.com%252Fwatch%253Fv%253DduNYHfvP_8U%2526feature%253Dyoutu.be%26amp%3Bdata%3D04%257C01%257CNathasha.Nickerson%2540gov.ab.ca%257Ce837d5f4bfc34101599208d8d89bb34c%257C2bb51c06af9b42c58bf53c3b7b10850b%257C0%257C0%257C637497511929140154%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C3000%26amp%3Bsdata%3DyslpRsQf268%252Fs3o6jJjcycsZFGE8bPCgBzCmUyQ2tME%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DduNYHfvP_8U%26amp%3Bfeature%3Dyoutu.be%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcan01.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fsocial.technet.microsoft.com%252FForums%252Fen-US%252Fe1c18dfc-fff2-4621-96a6-bd1a7a3903f4%252Fhow-can-i-add-a-new-column-to-the-workbook-so-data-can-be-entered-in-addition-to-the-results-loaded%253Fforum%253Dpowerquery%26amp%3Bdata%3D04%257C01%257CNathasha.Nickerson%2540gov.ab.ca%257Ce837d5f4bfc34101599208d8d89bb34c%257C2bb51c06af9b42c58bf53c3b7b10850b%257C0%257C0%257C637497511929140154%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C3000%26amp%3Bsdata%3D5f0QaRmSKT6lBCCf499DBIRlcuAP74s3hf%252BCE67Yc3Y%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fsocial.technet.microsoft.com%2FForums%2Fen-US%2Fe1c18dfc-fff2-4621-96a6-bd1a7a3903f4%2Fhow-can-i-add-a-new-column-to-the-workbook-so-data-can-be-entered-in-addition-to-the-results-loaded%3Fforum%3Dpowerquery%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2162778%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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...

Question from Sarada on StackOverflow:when you have SQL data imported in Excel via Power Query, you may want to add some comments to the data in Excel and ke...
1 Reply
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.