Hi,
I have a table in workbook "Worklist", which is used for daily worklist followup.
A seperate workbook is created "Vendor check" with a table connected to the "Worklist" table, this table has 3 additional columns where you can write Things about the vendors.
The issue is, when refreshing the table in "Vendor check", it refresh with the table as it is in "Worklist", but resulting in the 3 additional columns to end up in wrong Places if the "Worklist" data is not listed in the exact same order as last time it was updated.
Is there a way to let the additional 3 columns follow the unique identifier "Vendor ordreno.", so when the table is rfreshed the 3 columns data will follow the "Vendor ordre No."?
Reason for having the data in 2 seperate workbooks is that some people handle the worklist and other only do the vendor part.
Brgds
Thomas
I have a table in workbook "Worklist", which is used for daily worklist followup.
A seperate workbook is created "Vendor check" with a table connected to the "Worklist" table, this table has 3 additional columns where you can write Things about the vendors.
The issue is, when refreshing the table in "Vendor check", it refresh with the table as it is in "Worklist", but resulting in the 3 additional columns to end up in wrong Places if the "Worklist" data is not listed in the exact same order as last time it was updated.
Is there a way to let the additional 3 columns follow the unique identifier "Vendor ordreno.", so when the table is rfreshed the 3 columns data will follow the "Vendor ordre No."?
Reason for having the data in 2 seperate workbooks is that some people handle the worklist and other only do the vendor part.
Brgds
Thomas
