Hi,
Think im in the right thread,
I have successfully made a table query between 2 workbooks, but I would like to add additional information to the table in the workbook that is a copy.
So the first workbook contains contract information, and I want to have some of the data from this contract information in the second workbook, but then would like to add additional information to the contracts that is only required by myself, and don't want to edit the first table as it is already extremely complex.
But the problem i am having is that when i add data into the second workbook, and then add additional rows to the first table the data does not stay in line, is there anyway i can link the additional column so this data always stays in line with the correct data.
Bookmarks