Drop down list and transfering data to another sheet automatically

[cwby44]

Hello everyone
I am so glad I found this site - it has been eye opening to say the least.
I have a question however, I am in the process of creating a workbook of different things for my construction company and I am stuck. Is there a way that I can pull a cost code from a drop down and have whatever data is inputted into the cell to the right automatically transfered to a budget report (another sheet)?
Example - Inputting time for my crews - select a code from the drop down list say for "concrete" Then I input the crews hours per day in subsequent columns and then sum it up at the final column. Can the sum of the hours worked doing "concrete" then automatically be transposed to the budget in the "concrete" section?

I really appreciate any help and am very thankful for a sites like this that makes it much easier for this old construction worker.

[Melvinrobb]

What you are wanting can probably be achieved. Your best bet is to post a workbook with an example of what you want the final product to display.
Odds are Vlookup is the function you need.

[cwby44]

Here is a stripped down work book
Thanks

[Melvinrobb]

Put the following formula in C4 and drag down:

Please Login or Register  to view this content.

If you have a better understanding of the VLOOKUP Function, the following would also work:
=IFERROR(VLOOKUP(A4,'Time sheet'!$B$3:$J$6,9,FALSE),"")

[cwby44]

Melvinrobb
I appreciate the help tremedously. I have one question about the Vlookup function and the results. In my previous example there are 2 workers who both did the same time of work during the day. So, while the number of hours per day per guy sums up in the total column on the time sheet page, it only shows up as 1 of the values in the budget page. HOw do I get them to sum up on the budget page?
Thanks again for you help

[Melvinrobb]

In that case, you should use the SUMIF function:

Please Login or Register  to view this content.

That way you will get the total hours for each cost code.

[cwby44]

Whould it be the same "SUMIF" for the Vlookup function as well?

[Melvinrobb]

The SUMIF replaces the Vlookup formula.

[cwby44]

Sorry for being dense, but where in the Vlookup formula would you put the SUMIF? When I replaced the Vlookup with the sumif it gave me an error. Thank you for the help

[Melvinrobb]

I'm not sure why you were getting an error message.
The attached should work.