Hi All,
First post so please take it easy with me. I don't seem to be able to attach anything to show you the matrix i have but will try and explain the best i can.
I am looking to create a generating price list based on window size for curtain and blinds.
If i create a workbook and sheet one contains the price list, it would read something like, windows sized from 0-1000 for type a of curtain would cost £50. 1001 - 2000 type a would cost £75 and so on.
Similar for type b curtains etc.
Some prices, would also have to take into account a 3rd measurement (drop)
I would like to have a measurement sheet setup whereby all i have to do is enter the measurements on the windows within the house and then it would calculate the cost associated to curtain type a, curtain type b, blind 1 and blind 2 etc etc
Is this possible?
Thanks
Mike
First post so please take it easy with me. I don't seem to be able to attach anything to show you the matrix i have but will try and explain the best i can.
I am looking to create a generating price list based on window size for curtain and blinds.
If i create a workbook and sheet one contains the price list, it would read something like, windows sized from 0-1000 for type a of curtain would cost £50. 1001 - 2000 type a would cost £75 and so on.
Similar for type b curtains etc.
Some prices, would also have to take into account a 3rd measurement (drop)
I would like to have a measurement sheet setup whereby all i have to do is enter the measurements on the windows within the house and then it would calculate the cost associated to curtain type a, curtain type b, blind 1 and blind 2 etc etc
Is this possible?
Thanks
Mike
