I would like to have two worksheets, one that is a master sheet and one that is used by multiple people. My goal is to have the master sheet updated in real-time, or after saving, when the other sheets are updated. For example, I have several professionals who work with clients. It is not necessarily one client for one professional exclusively, there are times when a client for one professional may go and see another professional in the office. I would like to have a worksheet that contains fields for name, meeting date, and length of meeting. The expectation is that there will be multiple meeting dates for each client. When the information for a client is completed, I would like for his or her meeting information to be updated in a master sheet automatically.
The cells in both the master list and the dynamic list that will be populated range from C2 to AH2. In the dynamic workbook, when meeting date is updated in a particular cell, say C2, I would like C2 to be updated in the Master workbook, as well. I would like to have several dynamic workbooks, one for each person who needs one, and one master workbook that is only accessible by me
I do not have a sample, as I wanted to figure out the best way of going about this before starting. Thanks for your help!
Bookmarks