PDA

View Full Version : Master Workbook linked to Two Workbooks



Mooseman60
12-08-2010, 04:29 AM
I have a workbook (I'll call Master) that consists of multiple hidden worksheets that populate the main worksheet called Quote Template. This all works exactly how I want it to. Is there a way that i can store the Master Workbook on the server and have a copy of the Quote Template Worksheet on 3 different computers. When a person clicks on the validated combobox it pulls its data from the Master Workbook hidden worksheets on the server. Also on the copy of the Quote Template worksheet is a cell coloured red, when the user double clicks this cell it opens a pop up userform that the user can add additional items which would be stored on the relevant hidden worksheets in Master Workbook. When the user saves their Quote Template Workbook it is saved to a folder on the server as the Project Name which is stored in cell C4. Is this possible.

I have attached my Master Workbook