How can I link two workbooks to update formulas automatically ?
Please see these explanations from @AllanR. If you still have questions, please clarify your task.
