Hello. I have a number of levels I want to take this project, but this is a first step. I'd like to know if this first step could easily be done by recording macros or will some tedious vba programming be necessary or not. I'd like to describe what I want to do and include just an explanation excel file with a few values to give you a general sense of what I want to do.
In my programming as a first step I want to check the existence of certain required lengths against a list of stock. It is expressed in the way in the attached file:
I want encouragement on whether it is feasible to create VBA code for the user to click a "button 1" going down the quantities of each requirement, one by one, and checking the stock with the shortest pieces of stock to be utilized first, and if available, list on another table below in the excel worksheet which of the requirments were found to be available in the stock. And there is a column to the right which displays the dollar amount of the remaining material one the requirment is cut from the stock. Then assuming the stock will be used I want a "button 2" to be pressed to reduce the available stock length and quantities.
I am including an excel file here that has example requirments and available stock. I indicated in two green circles "buttons" which will ultimately have the macros assigned to them and the zones on the screen where the results will be shown. For simplicity sake, I would want the results to on the same worksheet so as to avoid the user needing to click on another worksheet for the resuls and going back and forth, but maybe I need a second sheet to list the results to have more space to display results that might not fit in the alotted rows on the same worksheet.
In summary, this first facet of the project is to check availability of a requirment against a list, cross checking, with a goal to use up the shortest pieces in stock first and to display the list. Dollar values of the remaining material will be displayed in a column on the right.
Any suggestions to improve this question or to provide clearer information is appreciated. Thank you very much.
Bookmarks