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 .
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.