Hi


"cjjoo" wrote in
message ...

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


And so what? You can as many additional columns on worksop sheet, as you
want.



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


The best way to get a history for a job is to use autofilter on workshop
sheet.


Arvi Laanemets