I would be grateful for your help.

I have a programme for inputting dates of any works that has starte
and completed including a duration and defect.

However in this programme there are two tabs, 1= Master, 2= Duration
Defect,

TAB1= MASTER

Kitchen:
In Column K5 Duration – any number to input
In Column L5 Defect - any number to input

Bathroom;
In Column T5 Duration – any number to input
In Column U5 Defect - any number to input

(Bear in the mind, there may have N.W.R (no work require) or D/
(disclaimer) in either or on it own or both kitchen and bathroom)

TAB 2= DURATION & DEFECT

Kitchen & Bathroom
D4 Duration
H4 Defect

Kitchen Only
J4 Duration
N4 Defect

Bathroom Only
P4 Duration
T4 Defect.

I require formulas/functions to help me to make this work:

TAB 1 = MASTER both kitchen and bathroom works has been completed, an
have duration and defect on both then all the information goes to TA
2= DURATION& DEFECT, kitchen & bathroom = D4 Duration and H4 Defect.

If in TAB 1= MASTER , N.W.R or D/C in Kitchen but work completed in th
bathroom, then all the information goes to TAB 2 DURATION& DEFECT
Bathroom only P4 Duration and T4 Defect.

The same as above if kitchen work only and N.W.R or D/C on bathroo
then goes to Kitchen only in TAB 2 TAB 2 DURATION& DEFECT, J4 Duratio
and N4 Defect.

Make any sense to you? Let me know if this doesn't!!!

Cheer

--
craig@hel
-----------------------------------------------------------------------
craig@help's Profile: http://www.excelforum.com/member.php...fo&userid=3620
View this thread: http://www.excelforum.com/showthread.php?threadid=56316