View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default auto populate different cells when selecting from drop down list.

See if this helps:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"abitanga" wrote in message
...
Help, can someone point me in the correct direction for this info! What I
am
trying to do is program a Excel spreadsheet to auto populate several
different cells when a user picks from a drop down list. So for example:
I
choose (January, 17 2002) and a seperate cell auto populates with the
(total
income generatred) and then another cell populates with the name of the
(person who generated the income). I have the data to create the list
just
don't know how to put it together or is this beyound me?