I want to use a combo box in one of the worksheets ("summary") to filter data in another worksheet ("data") within the same workbook. To populate the combo box I want to copy a list of unique values from the column A of the "data" worksheet and paste these values in one of the columns of the "summary" worksheet. I can then use these value as an input range of the format control for my combo box. The combo box control I am using is from Form toolbar available in excel. The data is not static so number of row and the number unique values will change every week.
Can someone please help me with code for this.