inventory tracking

[hd8]

I'm after using excel to keep track of an inventory list. I would like to have one worksheet that holds the inventory information and another worksheet where I can enter in how many of an item was shipped or recieved and it update the inventory worksheet. Any ideas on what would be the easiest way to handle this kind of thing in Excel?

Thanks for any help,
Joe

[VBA Noob]

Hi,

Maybe something like this

http://www.contextures.com/xlForm02.html


VBA Noob

[hd8]

Hi,

Maybe something like this

http://www.contextures.com/xlForm02.html


VBA Noob

That got it... Thanks for the help!

[lohni]

Hi

try Excel INventory Template and Tracker from http://abcaus.in

ashutosh

I'm after using excel to keep track of an inventory list. I would like to have one worksheet that holds the inventory information and another worksheet where I can enter in how many of an item was shipped or recieved and it update the inventory worksheet. Any ideas on what would be the easiest way to handle this kind of thing in Excel?

Thanks for any help,
Joe