hi
so here's my problem, i am building from scratch a spreadsheet that will do the following, allow the user to input the weight and measurement of an item, it will then calculate the volumetric weight and compare that to the actual weight of the item, it will also indicate which weight, actual or volumetric, to use, the user can then input a destination and the spreadsheet will look up the zones related to that destination and show all zones available for that particular country, so far i have all of this working, but now comes the tricky part, i have included a drop down list of all the products that we carry, with their weights and measurements, what i want to do is allow the user to pick an item from the drop down list and have the fields for weight and measurements populated by the information from the existing weights and measurement fields, rather than input them by hand, obviously the destination would have to be put in by hand, but i also need a way of being able to do this for multiple items, for which i have a set of fields planned so that each item will be added to the other so that a grand total can be calculated. i know that i probably haven't described this to well , if anyone wants to look at it so far i can post screen shots on here, what i am wondering is do i need to look at a pivot table or is this just formulas, hope someone can help.
Michael