I am trying to create a data generation VBA, hope someone could help me as I find it highly complicated, but I need the same for my work assessment.
Please see the attached file.
Sheet1 contains the data to be copied.
Sheet2 contains the sample that I require.

I have also created a user form. Now the combinations I require are as follows.

Firstly all the data from Column A in sheet1 needs to be arranged vertically in sheet2 removing the duplicates
Then all the date from column D in sheet1 needs to be copied to sheet2 removing the duplicates.

Now

1. When Type is selected in Combobox1 and All months is selected in combobox2 then how many times the particular item is appearing in given alphabet needs to be mentioned.

2. When Qty is selected in Combobox1 and All months is selected in combobox2 then qty should be written matching the given alphabet.

3. When Amt is selected in Combobox1 and All months is selected in combobox2 then Amt should be written matching the given alphabet.

4. Same way when Amt Or Qty Or Type is selected from combobox1 and month is selected from combobox3 then how many times the item appearing in that particular month needs to be mentioned.

The total in vertical and horizontal together with serial number and particualrs should be mentioned.

As the data keeps increasing whenever I put more data the total column vertical and horizontal should also shift accordingy

Lastly I need the caption on sheet2 row3 when following is selected with merge and bold

Combobox1 "Types" and Combobox2 All Months then caption as : "TOTAL TYPES FOR ALL MONTHS"
Combobox1 "QTY" and Combobox2 All Months then caption as : "TOTAL QTY FOR ALL MONTHS"
Combobox1 "Amt" and Combobox2 All Months then caption as : "TOTAL AMT FOR ALL MONTHS"

Combobox1 "Types" and Combobox2 (SELECTED MONTH) then caption as : "TOTAL TYPES FOR (SELECTED MONTH)"
Combobox1 "QTY" and Combobox2 (SELECTED MONTH) then caption as : "TOTAL QTY FOR (SELECTED MONTH)"
Combobox1 "Amt" and Combobox2 (SELECTED MONTH) then caption as : "TOTAL AMT FOR (SELECTED MONTH)"

Formating and Borders as shown with Font as Arial and size 10.