hi,

I have designed a sales sheet to be printed off after each sale on a trade counter.

The idea is I will enter a product code in 1 column which retrieves description and price, then enter quantity in another column which then totals (price * quantity).

this is repeated on say 15 lines, then totals all lines up adding vat etc.

This is all working fine using VLOOKUP, SUM

What I am hoping to do is include stock levels for each item in the database and somehow change them when a item sells

thanks