I am working on a moderately large project (1000 X 1000 cells). There is an original SPSS document that then is copy pasted to a intermediary excel document (called translation). There is then a main master excel document that queries translation. Master has multiple sheets and tables that all deal with the same data, sorting it with various functions. I made it a stepped process so I could see where the calculations break down a bit easier.

Basically, here's what I want:
the database is constantly being expanded with new research cases. I need to be able to expand ALL tables both in Translation and Master in one shot. Preferably, when new data is put in Translation the master will see how many new IDs there are and expand all the tables to match that. As it stands right now I have to manually autofill each table down, and while doing so with 25 or so tables isn't a lengthy process it is getting annoying.

So to boil it down, how do I hard-link the tables so they have the same number of rows?

My second question is if there is a way to have Excel query the actual original SPSS document, removing the necessity to copy paste each new update into my Translation.xl. The information (after being filtered and processed) is then put back in a new SPSS document... is it possible to automatically generate it or do I have to still copy paste?

Sorry if this is hard to understand. I can't post my database as it is sensitive material. If noone understands what I'm asking I'll make a sample but it would take me a half hour to make.

Thanks!