Personally, I would never work with linked workbooks, they always come a cropper eventually. Take all the sheets and put them in one workbook.
Then, explain step by step how you would calculate the excess without a spreadsheet, and we can try and work out what needs to be done.
Bookmarks