producing a cost matrix
 

Apologies in advance to the forum members for my lack of knowledge. I would really be obliged if I can get help on this problem. We make bespoke windows for a living.

I have to produce a height and width cost table and from that I can produce a price list by simply adding a profit margin to each size window.

Width starts at 300 (mm) and goes up in 100mm increments to 1600.

Height starts at 500 and goes up to 3000 again in 100mm increments.

I have a seperate sheet (a cutting sheet) that calculates the cost of the frame when you enter a given height figure and a width figure. The sheet calculates through all the given sections at their different sizes and hardware required and adds it all together giving me that final item cost.

To save me entering each size and recording the cost in to each cell of the cost table is there a way of automating the cost so that the cells fill up. In other words the cutting sheet size inputs are are taken from the height and width values on the cost table.

Thanking you for your kind help in advance,

Stuart

Could you attach the sample workbook here? Please attach it as a zip file.

Could you attach the sample workbook here? Please attach it as a zip file.

Thankyou for your speedy reply.

I have not attached anyhting to the site before so please bear with me whilst I get the work sheet ready to send to you.

Thank you again

Stuart

I can see how to attach now. Just got to ZIP the file. Please bear with me.

[quote=STUART BRAID;959334]I can see how to attach now. Just got to ZIP the file. Please bear with me.

Hope I have done this right.

[quote=STUART BRAID;959335]Darn! Your Height and Width have a lot of dependent formulated cells and it would have a very, very, very. very loooooooooooooooooooooooooooooooong formula per cell.

[quote=wickedchew;959363]That's what I thought having done something like this before.

Any suggestions as to a 'quick' way?

Cheers

Stuart

Thanks you for the post.