How to make Query table and normal table related?

[Akbarov]

Hi dear community,

Left table is query table ( which updates each month, right table is normal table, which has drop-down list, and users makes some changes.
I just want this 2 tables to be somehow related. so when user SORT data from left table, right table will move together.

Can anybody help me please?

 

[Coding4Fun]

So one obvious solution would be to combine them into one table and everything would sort together, however I assume this is not an option.

Another solution to this would be to reformat a bit and use a 3rd table. I know this may not be ideal but the only way I see to achieve what you are asking.

In your 2nd table add the column for the ID, so your 2nd table would be ID, Sales Team and Time

Your 3rd Table would be a copy of the 2nd table ID, Sales Team and Time.

In your 3rd table it would use a VLOOKUP based on the ID

Then when you sort Table 1, Table 3 will stay in line, Table 2 will remain static and would be manually updated

Again not ideal I know but its an option.