I have this spreadsheet I have to do once a month. It contains payment info from insurance companies. It’s a single worksheet and there are subtotals for each insurance company (number of companies and transactions can vary month-to-month).
I decided to make one giant spreadsheet with 12 tabs instead with a grand total tab at the end.
The grand total tab will have just the insurance company’s name and the total for the month and the grand total for each month and company.
Like this:
…Jan Feb … Dec…Total for ins co
Ins co. ......
Ins co.
.
.
.
.
… total for months… Grand total
How can I insert the monthly total from the individual tabs for each ins co into the grand total page?
Also, if you ever need to link to another .xls file completely (actually, to any cell anywhere, even on the same page), there is a button called ‘Paste Link’ under Edit → Paste Special…
Go to the cell(s) you want to link to, highlight them, do CTRL-C or Edit -> Copy, then go to the place where you want the links and Edit -> Paste Special -> ‘Paste Link’ button.
Never knew that. But let me share an alternative, even though it looks like the OP is answered. If you open the workbook (file) you want to reference, you can do the same thing that was described by Hampshire for referencing a cell in another worksheet (tab). In the destination, type “=”, then switch to the other file, locate the desired cell, and hit Enter.