linking a sales receipt worksheet to an inventory worksheet

T

Tator Bug

I have a sales receipt worksheet that has all my sales items on it. I also
have an inventory worksheet. I would like when I make a sale that it
automatically is deducted from my inventory worksheet. I have Office 2003
Example: Sales receipt is (sheet 4)
In each column
Item#-Description-Item Cost-Qty-Cost
Example: Inventory is (sheet 5)
In each column
Item#-Description-Cost- Qty Rec'd-Sold-In Stock
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vba to copy data from sale receipt to next available column in an inventory worksheet 0
Add total items in from another worksheet? 0
vba to copy data from sale receipt to next available column in aninventory worksheet 0
Is there a way to parse multiple values in a cell and applycalculations to those cell ? 1
inventory problem 1
transfer stock on condition 2
Need help creating a running subtotal 2
Mail Merge Help 1

Top