Hi
in this case I would suggest not to use VBA if you're
still learning Excel. Not sure about your inventory data
but one way to crate such a sheet would be the following:
1. Create a sheet with the following layout
A B C D
ID item In/Out Description
#1 item1 10 Buying new stocks
#1 item1 -3 Selling 3
#2 item2 30 Buy stocks of item 2
.....
Of course you can add additional columns (e.g. date,
comments, responsible, etc.)
Having such a database like structure would enable you to
create a status report for it. One way would be using
pivot tables for this. Find below some tutorial links:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm
HTH getting you started
-----Original Message-----
Frank, I am new to Excel. I took the intro class this
semester and going to the next level in summer. You lost
my on your reply. Can you explain farther? I built the
inventory program with Excel but did everything the Long
Hard way. I learned that in the class. Anything I can do
to keep from entering each item used in a case 1 at a time
would be great. I thought I could get multiple items
subtracted from inventory be setting a master to click on
and having it mean to Excel to subtract this group of
items from the list when I click on the master. Genedecrease by an amount when cell "A" is increased.I am
doing inventory, Cell "A" will be a case a Dr. does.
Cell "B" will be an Item in my inventory. If I increase
then number in cell "A"(meaning the Dr. did another case)
I want 1 subtracted from each item used in my inventory
list (Item totals in stock are in cell "B")
