Ok yeah makes better since the way you put things. Sorry about the one paragraph i can see how that would be irritating. Lets go off the format that you had.
I have two different sheets Normal and RAC - the only thing different from on and the other is the RAC has Sketch Drawings on it. The hours for this will aways be 12 and will need to be included in the total E33
There are three possible words entered into some cells
EXINSP
INSLIN
THICK2
Work No# can go into the cells
D7 EXINSP can at times be the only wo#
H7 INSLIN will always have an EXINSP wo# too
K7 THICK2 will never have an EXINSP or INSLIN wo#
THICK2 K7 will never exist if either D7 or H7 is completed
D7 and H7 can be populated with one or both.
there are numbers in D10 - D30 on Normal sheet and there are numbers D10 - D31 on RAC sheet.
The only reason B9 has a formula in it is so that when you enter in a wo# into the Thick2 K7 it will say "THICK2" in B9. And if B9 has Thick2 then there is no Inspector name assigned to this Circuit. If EXINSP, or INSLIN has a wo# in there cells then the page is just printed out and the scheduler will take and hand right in the inspector name for that circuit.
FROM THE NORMAL SHEET
D10 = "" if B9 = thick2 \ will always be 1 hour.
D11 = "" if D7 does not contain a work number for EXINSP \ will auto calculate by a % of the footage.
D12 = "" if B9 = thick2 \ will always be 2 hours
D13 = "" if B9 = thick2 \ will always be 2 hours
D14 = "" if B9 = thick2 \ will always be 2 hours
D15 = "" if H7 does not contain a work number for INSLIN \ will auto calculate when an INSLIN wo# is added
D16 = "" if B9 = thick2 \ will always be 2 hours
D17 = Sum of U11,U12,U13,U14 \ is auto calculated by a % of the Fitting # entered into N7,N9
D18 = Sum(D17*20%) its a percent of the hours in D17
D19 = "" if H7 does not contain a work number for INSLIN \ is a % based off the footage in H6
D20 = "" if H7 does not contain a work number for INSLIN \ is a % based off the hours in D19
D21 = "" if B9 = thick2 \ will always be 3 hours
D22 = "" if B9 = thick2 \ will alwyas be 2 hours
D23 = "" if B9 = thick2 \ will always be 2 hours
D24 = "" if B9 = thick2 \ will always be 1 hour
D25 = "" if B9 = thick2 \ will always be 2 hours
D26
D27 = "" if B9 = thick2 \ will always be 1 hour
D28 = "" if B9 = thick2 \ will always be 2 hours
D29 will have a number entered if service is needed but does not need to auto calculate
D30 will have a number entered if service is needed but does not need to auto calculate
E32 = The sum of hours for D1014,D22,D24,D27 for EXINSP only.
If INSLIN E32 should be =SUM D1015,D19,D20,D24,D27 \ This formula dont work
RAC sheet is just the same only difference is
E33 = The sum of hours for D1015,D22,D24,D27 for EXINSP only.
If INSLIN E32 should be =SUM D10:16,D20,D21,D23,D25,D28 \ This formula dont work
NORMAL SHEET THICK2 once a wo # is intered into thick2 K7 then B9 will say THICK2.
D10,D12,D13,D18,D2128 will move over to the L column. D11,D15,D1720 should have the 0's removed so that the cell is blank. This does not work to remove all the 0's.
RAC SHEET THICK2 Will never be used ever. the only time the RAC page will be used is when there will be an EXINSP and/or INSLIN.
I hope this is better than the one paragraph and this helps with helping me fix my document. sorry for all the trouble! thanks again for any help.