I have an Excel workbook that has the following sheets, "Main" and "Count":
Now the "Main" sheet has the column B with list of IDs.
Is it possible to have a macro on "Count" page to copy all distinct values in column A from column B in Main Sheet?
I know the Index function and Advanced filter will work, but I specifically need a simple macro.
Best Answer
Try this: