Controlling Stock Movements Using Excel vba

[Christian27]

Hii

Can anyone help with these questions, please?

1) Create a sub, function or macro transfers information from “In data” to the other relevant sheets.

2). The sub, function or macro must check if the required stock is available. If so, the order should be completed, and an order confirmation should be shown to the user. If not, a “Sorry, product X is not in stock” message should be shown to the user, and the system should inform the company to order more units of the product.

The excel doc is attached.

Kind regards,

Christian

[dominicb]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

In future please make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

I have changed this for you on this occasion.

DominicB

[Christian27]

Pardon

Will not happen next time.

Christian

[Christian27]

Can anyone help me with this?