Ok Here is what I got, I have two employees who work for purchase import section.
From Rising the IPO to having the LC created to have the goods delivered to the factory.
I have created a common grid header for each of them and they are populating it as I write this. I will then create a master sheet where I will put in the most import data and have it linked to the two employees who are working on it.
My question/requirement is, When each of this employee creates a new row ie new IPO
I want in the master sheet to auto create this row and which employee is handling it.
The Aim is to have a master sheet where the manager can see the most basic important information to make quick decisions, without any more intervention. While the secondary working sheet is used by the purchasing team to do its day to day job easier
Attach is a very rudimentary diagram, hope I am able to explain.
Thanks and Regards
