inventory tracking

Hello all.

I have been using excel to track my small nonprofit and was hoping to get it to the next level. Here is what I have been doing. I have been scanning in my stock of donations and supplies with a bar code scanner and have been having that number counted (as you will see in the example I am sending) What I am hoping is that their is a way to make the item name appear to the right of the scanned bar code (this will help if I scan something that I don't have in the system).

Or if anyone has any ideas on how to make things easier on my small organization.


I am also going to include the workbook (all hand done) I am using until I can get this thing figured out.

All suggestions are appreciated.


Another thing I am hoping for is the ability to keep track of where things go. So say I scan 2 things and they are going to Hospital A and 23 scanned things are going to Hospital B I am hoping to sort/copy those items to a different page or area with the date of donation.


Hope I made things somewhat clear. And don't forget I am New to excel in the advanced stuff.

Hi, Unfortunately I can not open your files, I'm using excel 2003.
I did think however that in order to place the item numbers against the Bar code numbers, you will need to place somewhere, a list of barcodes against the product names, then it is just a matter of a Vlookup or a bit of code to link the two.
Regards Mick

I agree with MickG. Take a look at this. MickG you can download a converter free from microsoft that will allow you to open the files.

I can save the file as 2003 once I get off work if you would like.

I will have to look at that. I have never used the Vlookup.