I need to create an algorithm or a macro on an Excel Files

General information for the business: Stock management on Excel
Kind of development: New program from scratch
Description of every module: Based on three sources of Information on one same excel spreadsheet (Stock In, Recipies and Cash Entries).
I need to match the Sales (Cash entries) with the stock available depending on recepies.
Description of requirements/functionality: For each cash entries, the macro / Algortihm should calcule the preparation made with the recepies in line withe the stock available.
I assume that the best way to approach it is to calculate the type of products that can be produced based on the stock available and their receipt.
And then input it for each cash entry.
Specific technologies required: Excel
OS requirements: Windows
Extra notes: If it can be as soon as possible it will be great.