Help - Excel macro to stock management

[pmlv]

Hello all,

I need your help

I have one file to stock management and i cant subtract the stock value

In the tab demand i have my client demand with the part number, the qty demand and the Stock OK?.

i want to search in the tab stock if the stock is enouf then put "OK" else put "NOK". when do the search it subtract the stock value.



example:

Tab demand range C2 = OK; Tab stock range B2=0
Tab demand range C3 = OK; Tab stock range B3=1
Tab demand range C4 = NOK; Tab stock range B4=-2


Can someone help me?

stock.JPG
Demand.JPG

[alansidman]

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

[pmlv]

Hello alansidman,

thanks for your the reply.

I put the file in attach. can you check if is ok?




regards,
Pedro

[Marc L]

Hi !

No need a code just using an easy VLOOKUP formula for example …

[pmlv]

Hi,

thanks for the reply,

with the VLOOKUP formula i do to have the stock value "OK" or "NOK" according to the stock in the stock tab but what i want it's to subtract the stock value when i do the VLOOKUP like the example bellow



Tab demand range C2 = OK; Tab stock range B2=0
Tab demand range C3 = OK; Tab stock range B3=1
Tab demand range C4 = NOK; Tab stock range B4=-2


thanks