I have workbook with 12 sheets in it. Each sheet represents months.
I would like to use UserForm ComboBox to display the data of each sheet.
I have created the ProductCode Combo Box & Monthly Labels, but I don't know how to extract data from multiple sheets.
Once the ProductCode selected in Combo Box, I would like to show its monthly sales numbers in front of respective monthly labels.
I would also like to display Fast Moving Item(Maximum number of sale in all 12 sheets) & Slow Moving Item((Minimum number of sale in all 12 sheets) for the year on this userform.
Thank you so much in advance