Jamie,

It seems like you want to do some basic permuations, which can be
accomplished with a couple of for...next loops in VBA. Provide further
details.

--
http://www.ExcelHelp.us

888-MY-ETHER ext. 01781474



"Jamie" wrote:

Dear All,

I am trying to make a basic sales cost calulator for my sales team. It
consists of lots of variables, of which I have managed to solve a few. The
main problem I have is the following:
I have 4 types of variables (more if I can use them, but 4 minimum) which
affect the price
1) Destination (6 options e.g New York)
2) Mode of transport (3 options e.g.Sea Freight )
3) Freight rate (4 options e.g $45 per cuft)
4) Destination rate (4 options e.g. full unpacking, not just curbside
deliery )

I have the above as options using Data - Validation drop down screens.
What I want to do is to get, for an example the cost for a job with X [units
of measurement] and the following responses:
1 - 4
2 - 2
3 - 1
4 - 4

All of the rates are on a seperate worksheet on the workbook, so I'll need
to be able to have a solution that is able to use a different worksheet
(unless I transfer everything on to the main one which is a possibility, but
not clean.

Can anybody exaplain, as basically as possible how I can do this please?

Any responses gratefully received.

Jamie