Hi
I have one excel file which is shared with many departments ( like sales, purchase , distribution and finance)
In this file we capture all sales orders and the status ( using drop down) of it. ( status are like, PO waiting, Approved drawing submitted, Ready to go, Material received...