C
cjjoo
the problem:
in my workbook , i got 30 sheets and they are name 1 to 30 ( for eac
day of the month)
the format of each sheets are similar and it looks like this:
sheet 1:
vehicle no date_in date_out action taken
x123 01/10/2005 chang
xxx
y456 01/10/2005 chang
yyy
z789 01/10/2005 01/10/2005 change zzz
sheet 2
x123 01/10/2005 chang
aaa
y456 01/10/2005
change bbb
in sheet 2, only x123 and y456 is shown (auto) since there is no
date_out in sheet 1.
and the date_in is given once a vehicle_no is issued. The formula is :
IF(A2<>"",DATE(YEAR(TODAY()),MONTH(TODAY()),MID(CELL("filename",B1),FIND("]",CELL("filename",B1))+1,99)),""))
so my question is :
it is possible for x123 to be assign again but it will return the dat
in
as 01/10/2005 instead of 02/10/2005 since it it an old job and not
new one? i hope it can be done by modifying the
above formula.
pls advise
in my workbook , i got 30 sheets and they are name 1 to 30 ( for eac
day of the month)
the format of each sheets are similar and it looks like this:
sheet 1:
vehicle no date_in date_out action taken
x123 01/10/2005 chang
xxx
y456 01/10/2005 chang
yyy
z789 01/10/2005 01/10/2005 change zzz
sheet 2
x123 01/10/2005 chang
aaa
y456 01/10/2005
change bbb
in sheet 2, only x123 and y456 is shown (auto) since there is no
date_out in sheet 1.
and the date_in is given once a vehicle_no is issued. The formula is :
IF(A2<>"",DATE(YEAR(TODAY()),MONTH(TODAY()),MID(CELL("filename",B1),FIND("]",CELL("filename",B1))+1,99)),""))
so my question is :
it is possible for x123 to be assign again but it will return the dat
in
as 01/10/2005 instead of 02/10/2005 since it it an old job and not
new one? i hope it can be done by modifying the
above formula.
pls advise