Question Locked
Linking multiple Excell workbooks
0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have one master workbook and 10 dependent workbooks. What I would like to do is have the dependent workbook automatically update with specific information from the master. I am trying to generate sales reports for individual salesmen. The master is set up with simple columns date/customer/product/price/sales#. I want excel to only pull only the information a specific salesman and place it in the dependent workbook. All workbooks are set up identically. Thanks for all your help.