Stock check function

Surpz

New Member
Joined
Sep 25, 2020
Messages
1
Office Version
  1. 2013
Platform
  1. Windows
Im Looking to add a stock check function into a basic stock management system i have created on excel (see below)

1601022327872.png


The order system at the bottom uses data validation with drop downs for all the variations of parts and then uses a macro on the green 'order' button which copies the data to a separate 'orders' tab. The data from that tab then populates the stock table using countifs.

My plan is to have the order system on its own tab and once the fields are populated using the drop down menus to select the variations it will then lookup the data from the stock table and display in the "in stock" and "on order" cells next the green order button.

Does anybody know if this in possible and how to do it?

Thanks in advance
 

Attachments

  • 1601019258428.png
    1601019258428.png
    71.3 KB · Views: 1

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Watch MrExcel Video

Forum statistics

Threads
1,122,828
Messages
5,598,336
Members
414,232
Latest member
MIA10_KO

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top