Updating tables but keeping rows together

[ArtofExcel]

I have a table that daily updates from an SQL server, this is then pulled into a new excel document through a Microsoft query. The rows of data can be deleted or updated daily on the SQL server. In the final excel document I added a few columns where where specifications are input using a data validation list so the data can be sorted into other tables. Each row has a unique indicator in one of the columns. But whenever I update the table the manually input specifications do not follow the SQL data as I had hoped so each one would have to be reset daily. Is there any way to make the manual inputs follow the imported data dynamically until the row its associated with is deleted in the SQL server or is filtered out by the query? I'd greatly appreciate any assistance in figuring this out.

 

[Comfy]

Use a separate table to log the manually input specifications along with a unique identifier that comes from the SQL data source.

You can then change your current table to VLOOKUPs so that no matter what row the record is moved too the correct specs will get allocated to it.

Ideally, you would get a custom table (for the input specs) added to your database and the SQL query would perform the JOIN.