Adjusting counts

**rodinman** · 01-18-2011, 10:28 AM

****Solved****

I have to sheets, one is a currentinventory and one is a packing slip. I want to be able to fill out the packing slip and have it adjust my inventory sheet. Can anyone show me how? Files are attached.

**NBVC** · 01-18-2011, 10:38 AM

With both workbooks opened, try:

=SUMPRODUCT(--('[Denver.xls]Packing slip'!$B$13:$B$37=A4),'[Denver.xls]Packing slip'!$F$13:$F$37)

copied down.

You might need to adjust the Total formula in I4 to: =B4-G4+H4 to account for the negative adjustment due to shipping...

**rodinman** · 01-18-2011, 10:41 AM

Thank you I will try that and report back

**rodinman** · 01-18-2011, 10:45 AM

I got a false. how much would you charge me to do it?

**NBVC** · 01-18-2011, 10:50 AM

See the attached.

**rodinman** · 01-18-2011, 11:42 AM

I think I just plain dont know how to work it. In my mind when I fill out the packing slip it automatically adjusts my inventory based on the numbers I input on the packing slip. does it look for the numbe on the packing slip in the iventory sheet and updfate?

**rodinman** · 01-18-2011, 11:57 AM

Ok, It works perfectly.. Thank you very much...

**NBVC** · 01-18-2011, 12:09 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save