fatalcore
02-20-2012, 07:06 AM
Hi,
I have a problem and I can't think about anything how to achieve it.
I have a "Restriction" sheet, which contains data of file and restriction, The point is if I have worked on File A - I can't work on File 1, File 2 and File 3.
If I have worked on File B - I cannot work on File 4, File 5 and File 6 etc.
I have another sheet called Workflow, where I intend to insert the files I have worked.
I have another sheet called Validity, where basically I want to run the test.
Here I insert the name of the file and click the button, then if there is a restriction as per "Restriction Sheet" Then It will be flagged else there will be a message that there is no problem and the data will be saved in the "Workflow" sheet with the date.
I am attaching a sheet for example.
Thanks in advance.
I have a problem and I can't think about anything how to achieve it.
I have a "Restriction" sheet, which contains data of file and restriction, The point is if I have worked on File A - I can't work on File 1, File 2 and File 3.
If I have worked on File B - I cannot work on File 4, File 5 and File 6 etc.
I have another sheet called Workflow, where I intend to insert the files I have worked.
I have another sheet called Validity, where basically I want to run the test.
Here I insert the name of the file and click the button, then if there is a restriction as per "Restriction Sheet" Then It will be flagged else there will be a message that there is no problem and the data will be saved in the "Workflow" sheet with the date.
I am attaching a sheet for example.
Thanks in advance.