Last line of manual entry next to query always moves to last line when query updates

%3CLINGO-SUB%20id%3D%22lingo-sub-3400932%22%20slang%3D%22en-US%22%3ELast%20line%20of%20manual%20entry%20next%20to%20query%20always%20moves%20to%20last%20line%20when%20query%20updates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3400932%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%20of%20credit%20card%20transactions%20for%20the%20company%20and%20separate%20spreadsheets%20for%20each%20cardholder%20that%20pulls%20their%20transactions%20by%20query.%26nbsp%3B%20The%20user%20then%20marks%20up%20their%20sheet%2C%20and%20I%20have%20a%20query%20pulling%20that%20information%20back%20to%20me.%26nbsp%3B%20The%20list%20is%20updated%20weekly.%26nbsp%3B%20Each%20transaction%20has%20an%20ID%20%23%2C%20and%20the%20users'%20queries%20list%20the%20transactions%20in%20ID%20order%20so%20that%20they%20don't%20get%20out%20of%20order%20with%20the%20user's%20notes.%26nbsp%3B%20I've%20noticed%20that%20any%20time%20the%20table%20is%20updated%20with%20new%20transactions%2C%20anything%20the%20user%20has%20manually%20entered%20on%20the%20last%20line%20of%20the%20previous%20table%20jumps%20to%20the%20last%20line%20of%20the%20updated%20table%2C%20so%20the%20notes%20are%20no%20longer%20next%20to%20the%20correct%20transaction.%26nbsp%3B%20Any%20work%20arounds%20for%20this%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3400932%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3401096%22%20slang%3D%22en-US%22%3ERe%3A%20Last%20line%20of%20manual%20entry%20next%20to%20query%20always%20moves%20to%20last%20line%20when%20query%20updates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3401096%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1394850%22%20target%3D%22_blank%22%3E%40Jenn_Waldman%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPower%20Query%20is%20not%20in%20sync%20with%20manually%20added%20column.%20Workaround%20is%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexceleratorbi.com.au%2Fself-referencing-tables-power-query%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceleratorbi.com.au%2Fself-referencing-tables-power-query%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a spreadsheet of credit card transactions for the company and separate spreadsheets for each cardholder that pulls their transactions by query.  The user then marks up their sheet, and I have a query pulling that information back to me.  The list is updated weekly.  Each transaction has an ID #, and the users' queries list the transactions in ID order so that they don't get out of order with the user's notes.  I've noticed that any time the table is updated with new transactions, anything the user has manually entered on the last line of the previous table jumps to the last line of the updated table, so the notes are no longer next to the correct transaction.  Any work arounds for this?  

1 Reply