Inventory Worksheet

P

Philip B. Power

Hello, I am preparing an inventory worksheet with +300 items and I am
recording opening balance, issues, receipts, adjustments and balance. I have
eough worksheet space for each item (I call it a separate card) to allow
multiple entires with a running balance occurring by formula.

I need the bottom of the item column (last line) to read the balance as the
lines above are adjusted for an inventory transaction, and this last line
will automatically adjust as entries are made.

If necessary, I can send a page of the worksheet to anyone that responds
with help or suggestions.

Thanks
Phil
 

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

Inventory List 3
Calculating an inventory balance at a "point in time" 5
AT WITS END ON QUERY TOTAL 34
combining queries into 1 8
3 queries into 1 8
vba to copy data from sale receipt to next available column in an inventory worksheet 0
Using Nz in inventory running balance 2
Attempting an inventory management database 7

Top