View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peterwnixon Peterwnixon is offline
external usenet poster
 
Posts: 8
Default Specific Data Ranges Produced From Drop Down Lists

Dear Sir or Madam,

I am currently constructing a user-friendly front page to a complicated
budget. I wish to generate the correct data range (i.e. daily rate of staff)
by utilising 2 drop down lists.

I wish the first list to enable the user to select either European or
American staff and the second to allow the user to select either "£", "$" or
"‚¬" currency for the daily rate of the appropriate staff. Ultimately I wish
the two drop down lists to produce a range of data in a fixed location that
would represent the rates for the results of the two drop down lists i.e.
European Staff daily rates in "£". Please could you let me know how I can do
this?

Kind regards & happy New Year.
--
Kind regards,

Peter Nixon