Specifying the row data should go base on first cell.

[potatopotatosalsa]

Hi, I'm working on an inventory management doc for clothing, and here are some background info:
I'm planning on having three sheets; data entry, inventory, and recent transactions.

Screenshot of data entry:
http://i.imgur.com/IHKvyS9.jpg?1
Inventory:
http://i.imgur.com/tmQJ3Xd.png?1

The inventory page will have all the item numbers in the first column, and all the different sizes (s,m,l,xl) in the first row, with the number of items we have on hand in the table.

In the data entry page I have boxes to enter the date, name of person pulling/putting back stock, item number drop down via data validation, and boxes for each sizes.

Recent transactions will just list all the recent transactions by date, name, and sizes.

My plan was to record a macro where the data entered on the data entry page will be matched up to whichever item number it's corresponding to on the inventory page, subtracting or adding to existing stock in the correct size, and then record the action to the recent transactions page.

The part I can't figure out is how to match up the data entered in the form to the Inventory page by item # chosen in the drop down in the form. If anyone can help me solve this problem it would be greatly appreciated.

[FDibbins]

Hi and welcome to the forum

1st, please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you

2nd upload your workbook here, not all members can access file-hosting sites like teh 1 you used (forewalls and stuff)

3rd, take a look at using vlookup or index/match to give you what you want

Thanks

[potatopotatosalsa]

Thanks for the feedback, workbook attached.

I uploaded it with one example of data entry, where Jon pulled 1 XS, 5 M and restocked 30 XTL of item # AA. This action gets recorded to the Summary page, and the appropriate number was deducted or added to the Inventory page. Again, my problem is that I can't figure out how to match up the rows in the inventory page according to what is selected as item # in the data entry page. I will be reading up on vlookup and index/match in the meantime.