[EXCEL VBA] warehouse system

[pandemic]

Hello there,

I have stucked on developing a warehouse system. I have created an accountancy book in excel 2010 and I want to know exact number of product (let´s say A and B) on Warehouse list. For example, let´s have 300 pcs of product A and B on Warehouse list. When I add 5 pieces of product A and 3 pcs of product B on the Order list it should immediately calculate that number of total pieces of product A and B on Warehouse list is 295 product A and 297 product B.

Can you tell me please how? If my explanation is too poor, click on the link below for more understanding. Feel free to ask me.

http://www.imagehosting.cz/?v=beznzvhmh.png

[mehmetcik]

Use the CountIf function.



Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[pandemic]

Hello, sample workbook added. If not clear enough, feel free to ask.

[mehmetcik]

Try these:

[pandemic]

Thanks, Ill try to implement it into my accountancy book and Ill let you know during the day if it works! At the first fast look it works perfectly even when I set the different order of product. Thank you and I appreciate your help and effort.

[pandemic]

Hello,

this order of product doesnt seem to work. It should be 298 of product A and 299 of product B in warehouse list. Sorry for bothering.

[mehmetcik]

Try This version

[Batul]

heyyy.., I want to draw warehouse design in staad.pro using excel vba ..but i cannot find vba code for it ...please help me ,i'm tired of it, please send me vba code file for warehouse design in staad.pro