importing headings from one sheet to another

[SalamanderSam14]

I have attached the spreadsheet i am working on currently. To enhance it i want to create another sheet which will imprt the names of the customers and total them as i have done for the job. However the jobs is a set list so input the fields myself where, the customer list will be forever expanding so i would like it to import the names in automatically when they are added. Any help with this would be great.

Im working in excel 2002 at the moment but am upgrading to excel 2010 by the end of the week if that makes any difference to the solution

[arlu1201]

Your question is not very clear. Can you please try and explain again using your attached file?

[SalamanderSam14]

sorry about being unclear ill try again.

I have uploaded another version of the spreadsheet. All i want to do is add a customer onto the time sheet in coloumn C, then if this is not all ready in the customer list on the customer total page, i would like it to be added automatically.

Hope that is a little clearer

[Fotis1991]

Hi

One way to do this, is using IF & COUNTIF functions and then use Auto Filter, to get your results, in column A(Customer Total_Sheet). Then in column B, use SUMIF, to get the Total hours/per name.

A>>> =IF(COUNTIF('Time Sheet'!$C2:$C$19;'Time Sheet'!C2)=1;'Time Sheet'!C2;"")

B>>> =IF(A2="";"";SUMIF('Time Sheet'!$C$2:$C$19;A2;'Time Sheet'!$B$2:$B$19))

Hope to helps you.

[SalamanderSam14]

thanks thats great ill ust create a macro to use the filter so it resets itself

[Fotis1991]

You are welcome!

Also thanks for the reb*