Unusual Inventory Workbook Need help

Maybe not unusual for some of you guys and gals but for me yes. If I am not clear about what I need please ask me.

I have an inventory sheet where I want to only input the buyers information on one sheet and with that information I want to select from a data validation list (which I already made) for the size and then the color.

I then want the inventory sheet to automatically fill in the appropriate cells with that information to keep a running inventory.

The Buyers Sheet has name, address, & phone (not important) then it has cells D "Harness Color" & E "Harness Size".

On the inventory sheet there is my "Current Inventory", "Beginning or Added Inventory" and "Sold" inventory.

I would like the SOLD area on the inventory sheet to pull data from the Buyers D & E Columns and automatically place the totals in the correct cells for each size and color.

It is linked below.

https://drive.google.com/file/d/0B6E...9XSUxhdHc/view

I have used 4 different browsers and hit the Go Advanced button and it will not let me use that button to attach my file.

I do not have any javascript blockers on any browser.

This is what it says at the bottom left of the browsers I am using. java script : void ('Attachments') not a popup just shows up when I click on the paperclip

Hi cat3rn,

1. Go to Advanced Post
2. Scroll down till you see manage attachments (Not the paperclip in the toolbar)
3. Choose File, Upload, and Close window

DMG

Tony, Didnt see your post when I click reply

See Attachment

That works great for getting the info from the buyers sheet to the inventory sheet. So how do I get the each drop down selections on the buyers sheet to report to the correct I column?

I want to be able to just select the color then the size and based on the selections for column D & E have column I add to its total.

for example I select in cell D3 Yellow and in cell E3 L then I would like cell I29 to read 1 (then that number would increase if there were more "Yellow" "Large" selected in their respective columns).

I think I need to use this function in the I column using the different colors and sizes.

Formula:

Please Login or Register  to view this content.