Forum Discussion

TNicker's avatar
TNicker
Copper Contributor
Feb 24, 2021

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 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://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fexceleratorbi.com.au%2Fself-referencing-tables-power-query%2F&data=04%7C01%7CNathasha.Nickerson%40gov.ab.ca%7Ce837d5f4bfc34101599208d8d89bb34c%7C2bb51c06af9b42c58bf53c3b7b10850b%7C0%7C0%7C637497511929130154%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=8YDEvstrIgaUUMhDxpw46a9StT2aWBdY1RCP14fekcA%3D&reserved=0 Self-Referencing table to make editable column

 

https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DduNYHfvP_8U%26feature%3Dyoutu.be&data=04%7C01%7CNathasha.Nickerson%40gov.ab.ca%7Ce837d5f4bfc34101599208d8d89bb34c%7C2bb51c06af9b42c58bf53c3b7b10850b%7C0%7C0%7C637497511929140154%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=yslpRsQf268%2Fs3o6jJjcycsZFGE8bPCgBzCmUyQ2tME%3D&reserved=0

 

https://can01.safelinks.protection.outlook.com/?url=https%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&data=04%7C01%7CNathasha.Nickerson%40gov.ab.ca%7Ce837d5f4bfc34101599208d8d89bb34c%7C2bb51c06af9b42c58bf53c3b7b10850b%7C0%7C0%7C637497511929140154%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=5f0QaRmSKT6lBCCf499DBIRlcuAP74s3hf%2BCE67Yc3Y%3D&reserved=0

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    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.

Resources