Hi
If you have a list of rates that remain static, atleast for a period of time, you can type these rates in one column in consecutive rows, and refer to this list with validation.
Put the list way out of site somewhere, pick your cell in which you want the dropdown, click on Data, Validation, Allow, List, Select(Highlight) the list you formerly created, Make sure "In Cell Dropdown" is checked. If you want this in more than one cell, Copy current cell, choose the cells to paste, right click on these, choose paste special, choose validation.
This will provide a dropdown in a cell or cells with the values you predetermined.
There may be other ways, but this should work for you.
Have a nice day!
Tom
This message was edited by TsTom on 2002-03-29 06:58