View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Frandonn28 Frandonn28 is offline
external usenet poster
 
Posts: 1
Default What excel function can I use in making a form that auto populate

My boss asked me to make an estimation sheet form. In one of the colums, I
was asked to make a drop down list for all our 48 A/C products to eliminate
error. For every product, I have the corresponding value for horse power,
Cap. BTU and Pwr.KW. My boss wants that these cells/fields be automatically
be populated once the engineer chooses the A/C product from the list. I dont
know the function to use and how to do it. I desperately need your help.
Thanks!
--
thanks =)