Hello dear excel lovers.
I am new to this wonderful community and I am also new to the field of VBA excel. Every day I try to learn new things.
I would like to mention that this is a topic given by a professor in order to enter the entrance exam.
If you could help me and if you have time, in creating a userform that would search for me and calculate according to 2 criteria (product code and date) the following products according to the attached table.
According to the images attached to the user form
* the first boxes (textbox and combobox for data) are the search criteria
* the following boxes are with the answers I want to find out according to the above criteria (textbox and combobox for data). But here I got stuck.
A structure (Product code) can be made up of 1 or more packages (Product name), if the structure has several packages (ex k1, k2, k3, etc) to show me the boxes with results depending on how many packages it has structure. If the structure has 2 packages, 2 rows of results should appear to me, if it has 3, 3 rows of results should appear to me, if it has 1, only 1 row of results should appear
* the next step is to calculate the total amount of quantities for each package according to the selected date
* the next step is to calculate the total amount of quantities for each package from the first date in the table to the final date in the table. But the same condition applies as the one above the rows of results will appear depending on how many packages the structure has.
The final step is to add the data resulting from the above process to the next sheet (PROCES). Provided that the structures that have more packages the total amount to be in a joint cell depending on how many packages it has. that is:
if the structure has 4 packages the cell merges from 4 cells if it has 3 packages to merge from 3 cells and with the desired result.
I will attach 3 images that may clarify you in what I said above. P.S. Thank you for your time .
Bookmarks