I have a set of data in one column of "Sheet 1". I want to remove the duplicates and delete all empty cells. However this set of data with removed duplicates and deleted cells shall then be posted in "Sheet 2". The button to activate the duplicate remover and empty cell deleter shall be on a third tab "Sheet 3".
Attached is an excel file which shows the task and the desired output.
I am sure this is pretty basic but please help me as I am an absolute beginner regarding VBA.
Thanks in advance.