I’m working on calculating the difference of values in the Database tab Column F “Completion”.
To determine what two values to calculate it needs to cross-reference and find identical values in Database Column B “Barcode” AND Column K “Time” AND Column N “Tasks” and possibly Column O & P “Check-in/out” if needed to simplify the cross-reference.
These values should then be summed up and populated in the “Weekly Summary” tab table according to Zones, Date, and Tasks.
If there is one out of two missing = color weekly schedule cell red.
Choosing/writing a date and then that week’s summary populates in the table would be the best but I have no idea where to start on that.
I have reached out for something similar before but after some time the table becomes invalid, and it takes a toll on the sheets size and reaction time.
I have to admit that I am way out of my depth on this and I really hope someone can come and say it's easy.
Any suggestions on how I should approach this would be great. Formulas or VBA.
Attached is the sample workbook with the existing, none working, weekly schedule formula.
All personal names have been made by a name generator.
I hope this is clear and that I'm on the right track.