mateo_feo
08-21-2008, 08:48 AM
Dear all
i regularly use a pricing sheet like the attached. The user must filter from left to right in the columns to get a unique row. From that unique row, there are several pricing rates which, when multiplied by the weight of a shipment will produce some pricing fees: pickup charge, airfreight charge, delivery charge...etc.
Example: the user filters for the country of origin, city of origin, country of destination and city of destination and will get a unique row. That row, when used with the weight of the shipment on hand will allow the user to calculate the charges.
What I would like to do is create a userform that has dependent comboboxes that narrow down the filter and then on a new worksheet calculate the rates for that row based on the weight that they have for that shipment.
I can do the userform and the calculated cells, but where I am stuck is the dependent comboxes.. can anyone provide a similar example that i can look into and get started? Any help is most appreciated.
p.s. i know that a relational database is better for this, but this is what I have to work with..
i regularly use a pricing sheet like the attached. The user must filter from left to right in the columns to get a unique row. From that unique row, there are several pricing rates which, when multiplied by the weight of a shipment will produce some pricing fees: pickup charge, airfreight charge, delivery charge...etc.
Example: the user filters for the country of origin, city of origin, country of destination and city of destination and will get a unique row. That row, when used with the weight of the shipment on hand will allow the user to calculate the charges.
What I would like to do is create a userform that has dependent comboboxes that narrow down the filter and then on a new worksheet calculate the rates for that row based on the weight that they have for that shipment.
I can do the userform and the calculated cells, but where I am stuck is the dependent comboxes.. can anyone provide a similar example that i can look into and get started? Any help is most appreciated.
p.s. i know that a relational database is better for this, but this is what I have to work with..