Password Protected Drop Down List

The best way is not to have the data from the other offices available at all.

Can we back out a step and have you explain how the data are organized?

What I am thinking about is that you have a master workbook with a program to break out the data by office. You ship the individual workbooks to the separate offices. When they send the workbooks back, you use the data in those workbooks to update the master workbook. Does that sound like something you can support?

If so, provide a sample workbook with sanitized data for two or three offices.

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.