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