Click the cell you want to link to another cell in another doc. Hit the
equals sign and click the tab/window for the other doc and click the cell you
want it to correspond to. Hit enter. That's it. If you do this three times or
so in a column on each page, you can highlight those cells and go to the
bottom right of the highlighted cells with your cursor (you will see a
plus-sign type icon) and drag it down. It'll repeat the pattern. There's
probably a formula for it, but I'm much too lazy for formulas.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
