My first post on hear and to be honest a complete novice to Excel
I need help in two ways, would very much appreciate anybodys help.
I need to produce a spreadsheet to use as a price list. Its for my window company and I need to be able to input a width and height figure in to cells on a seperate sheet to reach a price (it also needs to round up if someone inputs a size slightly over one figure but under the next....if that makes sense? I have 50 or so window styles which all need a grid. Can anyone please help me with this?
Also I would be interested if its possible that once the price grids have been done for me to be able to incorporate a method of 'four corner pricing' ie that i only need to input a figure in the four corners of the matrix manually and the rest are then calculated for me, this is purely just to save me time rather than having to input every figure for ever style.
All this seems impossible to me but looking at some of the help and guidence you guys have given to others....I'm keeping me fingers crossed and would be eternally grateful.
Thanks in advance.