I have 2 workbooks that I need to copy a worksheet from one to the other and still maintain formual integrity. All of the sheets are identical in both workbooks. There is 1 sheet that needs to updated on a per job (leak audit) basis. That sheet is called flow rate. The flow rate sheet has formuals in it that connect to another sheet in both workbooks (audit sheet). When I copy the flow rate sheet over to workbook B the formulas in the audit sheet break, even though it is named the same. Is it possible to move this without breaking the formulas?
Thanks
Thanks