R
ReD-DevIL
thanks alot :
F
funkymonkUK
when you need this by
F
funkymonkUK
Question.
PEM is what happens to each equipment?
So will each epuipment have a PEM and CAL?
So are you asking is PEM and CAL are on the same month or a month late
no matter what equipment it is will be moved to the earlier date
PEM is what happens to each equipment?
So will each epuipment have a PEM and CAL?
So are you asking is PEM and CAL are on the same month or a month late
no matter what equipment it is will be moved to the earlier date
R
ReD-DevIL
Maybe two weeks later, i'll propose the new format to my superviso
later today, depends on whether he want to change the format.
Regarding the PEM and CAL i don't actually get your question, haha m
english quite poor. Maybe i try explain again. I use the example yo
gave so you can visualise better.
You have PC, Desk chair, Printer etc. All these equipment have two typ
of maintenance namely PEM and CAL. Example PC's PEM maintenance is du
on 15/3/2006 while its CAL maintenance is due on 16/4/2006, thats fin
PC's both maintenance can be done separately because the difference i
more than a month. But if Desk chair PEM maintenance is due on 22/04/0
and its CAL maintenance is due on 1/05/06 then both maintenance have t
be brought forward to 21/04/06 a day before the earliest due date. Th
PC and Desk chair maintenance date not definitely on the same date
later today, depends on whether he want to change the format.
Regarding the PEM and CAL i don't actually get your question, haha m
english quite poor. Maybe i try explain again. I use the example yo
gave so you can visualise better.
You have PC, Desk chair, Printer etc. All these equipment have two typ
of maintenance namely PEM and CAL. Example PC's PEM maintenance is du
on 15/3/2006 while its CAL maintenance is due on 16/4/2006, thats fin
PC's both maintenance can be done separately because the difference i
more than a month. But if Desk chair PEM maintenance is due on 22/04/0
and its CAL maintenance is due on 1/05/06 then both maintenance have t
be brought forward to 21/04/06 a day before the earliest due date. Th
PC and Desk chair maintenance date not definitely on the same date
R
ReD-DevIL
Hi, my supervisor rejected the new format, he prefer the master recor
to be in graph form and viewable in terms of work week. He has alread
build the code for the master record and he wants it in thi
form(attached file
+-------------------------------------------------------------------
|Filename: Master Record.doc
|Download: http://www.excelforum.com/attachment.php?postid=4511
+-------------------------------------------------------------------
to be in graph form and viewable in terms of work week. He has alread
build the code for the master record and he wants it in thi
form(attached file
+-------------------------------------------------------------------
|Filename: Master Record.doc
|Download: http://www.excelforum.com/attachment.php?postid=4511
+-------------------------------------------------------------------
F
funkymonkUK
hi i been playing aroudn with it. but cant seem to come up with a
solution. sorry about that. unfortunately its beyond my excel ablities
solution. sorry about that. unfortunately its beyond my excel ablities
R
ReD-DevIL
It's ok. 
Maybe you can help me bit by bit...
I have a serial number for every equipment.
E.g.
sno date
1 21-mar-06
2 22-mar-06
3 23-mar-06
Once the user delete the number 2 records, the number 3 will move up
but the serial number remains as 3 how can i code it to adjust the
serial number when a record is removed ?
Maybe you can help me bit by bit...I have a serial number for every equipment.
E.g.
sno date
1 21-mar-06
2 22-mar-06
3 23-mar-06
Once the user delete the number 2 records, the number 3 will move up
but the serial number remains as 3 how can i code it to adjust the
serial number when a record is removed ?