Hi,

I run a retail store and use excel to keep a list of all products sold by
having a source page where all the info is stored about all products and then
i have a page linked to the source page that when i enter the product number
the description and selling price of the product appears. This has been a
good way of just keeping a list/database of sales.

What i would like to do is to create a form where i could link the form to
the source and enter the product number on the form and then the product and
the description would appear on the form, i would then have an cell where to
enter the amount tendered and the change that must be given to the customer.
After the sale is complete i would like that item that was sold to be added
automatically to a database which i could use to see our daily or weekly
sales.

Any help would be appreciated.

Louis.