If you provide details about your workbook, someone may be able to help
with a specific solution.
For example, is the staff list the same for European and American, with
only the rates different?
Do you have tables with staff and rates?
What do you need in the "range of data in a fixed location"?


Peterwnixon wrote:
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?

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html