I am looking for a procedure to add to my personal.xlsb. The intention of this procedure is to report unique values based on a selected column from one sheet and transfer it to another sheet:
1-Display inputbox which says: “Please select one of the cell related to the column that you to transfer unique values.
2-Create “UniqueValues” sheet in order to transfer it unique values from selected column into column A of “UniqueValues” sheet.
If “UniqueValues” already exist keep it and create a new “UniqueValues(2)
I attached an example file.
If you have questions, please contact me.