Dynamic Two way Link between multiple spreadsheets in a single workbook

[Ron Haynes]

Hi,

Let me start by explaining the purpose of my workbook. I co ordinate and monitor 200 vehicle builds from start to finish over a 42 day period on average.
There are 5 departments all requiring access to a spreadsheet containing our current stock.
Each department has a section with in our stock spreadsheet to keep up to date relative to their operations.

What I need:

New Arrivals Spreadsheet two way link to: Stock Spreadsheet , Parts Spreadsheet , Fabrication Spreadsheet , Fit out Spreadsheet , Sublets Spreadsheet

The New Arrivals spreadsheet needs to be able to allow me to paste new data from external source.

All the sheets contain the same information, but I need each department to have its own spreadsheet to work in so they can set the view by "date in" or "customer" however they wish. So the Link needs to be able to recognise if the sheets are listed in different orders.
Ideally each sheet requires a department password and will be locked so only columns relating to that department can be updated by them.



IF this is achievable it will save a lot of inter department correspondence.

Cheers

Ron

Book1.xlsm
	U
25	Working
Stock

Cells with Data Validation
Cell	Allow	Criteria
U2:U351	List	NA,Working,PD Only,Prebuilt,Complete

 

[earthworm]

You can do this my marking worksheet as shared workbook . However once the workbook is set as shared you wont be able to password protect it .

 

[Ron Haynes]

You can do this my marking worksheet as shared workbook . However once the workbook is set as shared you wont be able to password protect it .

Hi earthworm,

Thank you for your input , but the password is an important criteria.

Regards