Additional Columns in a connected table

[cjwatts]

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.

[alansidman]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[cjwatts]

Please find attached

As you can see if you had a row between row 2-3 in the master (old) version of the table, it then does not keep the data in on the right of the query table in line with the data