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