So I really have no idea how to accomplish this and I am hoping for a little bit of direction. I have a list of employees and their hours worked and what project they that code their 40 hours to. I import all that from a single CSV into "TableImport" every week and do my thing with it. I also have an employee table with all their info, and a projects table that lists all the projects we have going on. A new thing is that about 50 of these employees now need to split their hours between 3 projects each week (lets call them ProjectA ProjectB and ProjectC) at 50% to ProjectA, 30% to ProjectB and 20% to ProjectC. I have set a flag on these employees in the employee table, but I need to add some sort of check to my import so that when it finds those employees that are flagged, it checks to make sure that the hours that are imported are split up at that 50/30/20
What is the best way to do this? I am so lost, thank you for any help!