General discussion


linked formulas

By mbennett ·
More detail on my first question. I have one workbook with 25 workheets for 5 employees, 15 catagories on each, representing 5 potential work periods for each day. At the end is a total sheet to tally the daily totals.
The second workbook is linked to pull out the numbers from the total sheet on each daily workbook. Need to copy the formula and keep the relational stuff that does works when you are working inside one workbook

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

linked formulas

by DKlippert In reply to linked formulas

Here's the spreadsheet. There may be a more elegant solution, but first open all of the workbooks.
Type the equal sign in the first summation cell and then go to Window and locate the first sub workbook. Click the cell and then type +. Do this witheach workbook until you have a formula that looks like:
='[Dec. 6, 2001.xls]TOTALS'!$B$6+'[Dec. 7, 2001.xls]TOTALS'!$B$6+'[Dec. 8, 2001.xls]TOTALS'!$B$6+'[Dec. 9,2001.xls]TOTALS'!$B$6

Remove the Absolute indicators ($'s). Now copy that formula.Select all of the destination cells holding down the Ctrl key. Now Paste. The formulas will adjust themselves.

Related Discussions

Related Forums