User Form

[singupalli]

Hi

I need assistance.

i want to create Inventory sheets and sales sheets.

1) i want to use user forms to record my Inventory
Date, Location, Quantity, balance QTY, Invoice #
(Location, it will be either Store or slaes) when sales is mentioned, the balance qty shd minus from the store qty, and when sales is mentioned teh invoice numberr is a must.

2) Sales Sheet
Date, Invoice #, Customer Name, QTY, amount
(entry via a user form)

thats for now.

thank you