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.

2 replies

by thumbsup2

In Excel, click Help. Search on "Create a link to another workbook"

This will give you a list of help articles that will guide you through the process. The specific article you want to click on is "Create a link to another cell, workbook, or program".

This discussion is closed to new replies.