Never really delved all that much into Excel before - not to this level any
way so I’m hopeing someone can hold my hand through this. It should be an
easy one for someone:
I am trying to design a simple order form. If I enter a product code into
column A, I want it to fill in the product description, pack size and price,
in columns B, C & D leaving me just to fill in the total quantity in column E.

Then at the end, it should just have a list of the products my customer has
ordered in a nice printable page for the sales dept to process. (I can
probably do the aesthetics and simple calculations)

Hope this makes sense.

Kind Regards.