I have three sheets named Sales, Production and Logistics. I have a column named Order Status. I have created three name ranges (stat1, stat2 & stat3).
Now my question is if a user from any of the above mentioned departments choose the current status of an order, the same should be reflected in the other two sheets.
Ex: If a guy from logistics select "pending delivery" both the sales team and Production team should see the same and vice a versa.
Can somebody please help me with this??
I sincerely appreciate all your help and Thanks a ton in advance.
** Find the sample sheet attached.
Now my question is if a user from any of the above mentioned departments choose the current status of an order, the same should be reflected in the other two sheets.
Ex: If a guy from logistics select "pending delivery" both the sales team and Production team should see the same and vice a versa.
Can somebody please help me with this??
I sincerely appreciate all your help and Thanks a ton in advance.
** Find the sample sheet attached.