Hi,

I have 4 separate data sets in 4 separate worksheets. Using a user form I need to display a form that allows the user to select the type of summary. The possible options need to be (i)region summary: obtain the region and find the summary (ii) product summary within the region (iii) product summary across all regions: obtain the product and find the summary for the product across all the regions (iv) find the summary for all regions. The summary needs to be on the 5th sheet.

Thank you.
Problem1.xlsx