Colur Coding pick up

[chill3r]

Hi Peeps

great forum here, loads of info about

heres my question, i have a spreadsheet of current working times for our employees and ive colour coded each employee time to show were they were working on the certain day - is there a way i can pick the coulerd cells up with the certain hours in and drop them into another sheet as a final total of hours for that person so i can then invoice the comapny for the hours ?

if you need any more info then i can provide

thanks

Stu

 

[chill3r]

any ideas anybody ?