Hi I have a question for someone who hopefully got an answer lol... Im making
a spreadsheet for billing for my company I work for (We contract for
Comcast). We have codes for each job performed... Now on sheet2 of my
project I have made a column for "Codes", a column for "Code Descriptions", a
column for "Total Cost", and a column for "Total Miles" and filled each cell
in accordingly with the data I need.... What Im trying to do is on sheet1,
create a drop down box with the "Codes" in it... Now I know how to make a
drop list with the "Codes" but how can I get it to fill in the information
(Code Description, Total Cost, Total Miles) into the corresponding columns
automatically when I click on a code out of the drop list? I do not want to
have to manually select each code, each code description, each total cost,
and each total mileage each time I select a code because it kind of defeats
the purpose for my boss... Is there any forumlas or any functions or ANYTHING
I can do to have this happen lol??? Thank you for your time!

PS- I have not used Excel since high school soooo its been awhile! Thank you!