hi guys , appreciate the feedback u all gave. but the thing is that in
column E to I

there are other headings like : problems identified, action taken ,

action_by_which mechanic , time_in_ by mechnic, time_out_by_mechanic

then there is another sheet(named summary) where it is the
consolidation of all

the 30 sheets. So in the summary , i can see the history of all the
unique job

sheet Id and the repairs that has been done by which mechanic.

I dun noe if this is the best way , please advise.


--
cjjoo
------------------------------------------------------------------------
cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916
View this thread: http://www.excelforum.com/showthread...hreadid=476166