Quotation Project

Hi,

First post on here and i could do with some help if anyone can help me!

I am doing A Level ICT at 6th Form. I have chosen to create a quotation for a printing company as a minor project. The project needs to be able to create a quotation from the requirement's inputted.

I am have become stuck in the design stage and could do with a few pointers if anyone could suggest some.

Obviously there are many different products in the printing industry and each product vary's.

I proposed to make this through look up tables but would this work?, if not does anyone know how i could make this?

Many Thanks

Alex T

I have included what i want the system to do.

This sheet will form the basis of the product table. Now will i be able to create a user form that takes the name/code of the product, adds profit and delivery if neccesary to this and then adds vat to it?

If this is possible how do i do it?

Thanks for the help!

Alex

Having looked at your design, it will not give you the desired results in its current format.

in order to make Vlookup (or any other lookup) work you need to have all your data listed in columns, and not have merged cells

i suggest you re-arrange your data in the following 4 columns

Product Code, Description, Quantity and Price.

it should then be relatively simple to create lookup lists and perform the calculations you wish either on a sheet or a user form

Like this?

Thanks

Alex