nedy_03
01-22-2007, 03:18 PM
Hello,
I'm having this situation: two worksheet "REPORT" and "NOT WORKED or NOT REQUESTED". In both of them I have on column A the names of employees. In the first worksheet for each day I have to put for every employee the number of hours worked in the specific field: "lcrt/trng/pb.th client/pb. Th. GRS/not requested/absent/intv" ... the columns of interest are the pink ones :P ... If I put something in them in front of the person that was "absent" or "not requested", in the second worksheet I need to be written "absent" or "not requested"
EX: if in "REPORT!H4" I heve, let's say, 4:00 (hours) in "NOT WORKED or NOT REQUESTED!D3" I need to be written "not requested" and if in "REPORT!I4" I have 4:00 (or any value) , I need in "NOT WORKED or NOT REQUESTED!D3" to be written "absent".
Please help ... the request would be more complex but for the moment I would be very grateful if u help me on that ...
If is to complicated with two worksheets let's supose that we have two worksheets in one main worksheet! Maybe I will figure out how it works and do it myself :D .... until then need u guys! :banghead:
Thx,
Nedy
I'm having this situation: two worksheet "REPORT" and "NOT WORKED or NOT REQUESTED". In both of them I have on column A the names of employees. In the first worksheet for each day I have to put for every employee the number of hours worked in the specific field: "lcrt/trng/pb.th client/pb. Th. GRS/not requested/absent/intv" ... the columns of interest are the pink ones :P ... If I put something in them in front of the person that was "absent" or "not requested", in the second worksheet I need to be written "absent" or "not requested"
EX: if in "REPORT!H4" I heve, let's say, 4:00 (hours) in "NOT WORKED or NOT REQUESTED!D3" I need to be written "not requested" and if in "REPORT!I4" I have 4:00 (or any value) , I need in "NOT WORKED or NOT REQUESTED!D3" to be written "absent".
Please help ... the request would be more complex but for the moment I would be very grateful if u help me on that ...
If is to complicated with two worksheets let's supose that we have two worksheets in one main worksheet! Maybe I will figure out how it works and do it myself :D .... until then need u guys! :banghead:
Thx,
Nedy