First, let me say, I am a novice at Excel.

I have a large spreadsheet that I have compiled to keep track of documentation. This is set up in a table so that I can sort different columns.

Within the same spreadsheet I have another table that has some of the same documentation that I need to keep separate from the large table, but need to be able to keep the data the same in each table when I sort it. What I tried was in the second table just putting =A305, which is the cell in the large table. This works, until I sort it and then it moves the data to another cell.

Is there anyway I can link the data so when I sort, my link keeps up with where the data moves to? I would need to do this on the same spreadsheet as well as on a different spreadsheet. Is this possible?

I am unable to post an example of my spreadsheet due to work related.