Actually, they are as follows:
Thanks for that, they make more sense than what I had. But I don't think that is what you formulae do. For instance, the eligible morning meal formula, AD14 says
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=IF((V14="N"),"T", IF(AND(V14="Y",W14="Y",X14="Y"),"T","F"))
V14 says Y or N for employee, that suggests to me a non-employee always gets a morning meal (doesn't sound appropriate, but the formula seems to give it).[/FONT]
I have just tried to add a row for a non-employee, leaving at 10:00 am and returning at 11:00 am and the form shows morning and midday meals checked.
Then, the expense codes also come into play depending on if they are an employee or not and if they are in-state or out-of-state and whether it is an overnight trip or return trip.
I can see the in-state/out-of-state in columns Q:S, but where is the expense code checked?
I have the cells locked down and am now trying to also do coding to remove 'added' rows when the form is cleared. I'll figure it out... just takes a little time to research everything.
Why don't you let me to that bit, I am changing so much code (trying to make it easier to read and more easily maintained) that I think we make be changing the same code, and therefor might lose it.
BTW, can you also tell me why that you have formulas in B11 and D11 to check if non-employee and suppress the input, seems pointless as you don't suppress E11, F11, and H11, and you hide the row anyway.,