Stock management with Macros?

Hello

I just made a table for stock management thanks to a stock management table that I downloaded on this forum with a macro, I hope it will make my life easier. On the other hand, I would like to integrate the requester and type of table if possible. I am enclosing the excel file, thank you in advance for your answers.

I would like to put the requester and table type columns in the MVTS sheet.

(When I type a quantity in the window that appears, another window appears, telling me that the quantity in stock is less than the quantity requested, knowing that the quantity in stock is greater than the quantity entered for issue)

I don't know much about macros.

I hope to detail my problem

thank you in advance

Kind regards


gestion_materiel_macros-1.xls