Deleting duplicated data.....

[hello its dean]

Hi guys..

I have two sheets. One of them has a long list of numbers and the other one has a shorter list, all of which are also on the first sheet. How can I automatically delete the second sheets numbers from the first sheet?

Cheers

[AlKey]

You can removed duplicates by using Excel feature Remove Duplicates located under Data tab.

[hello its dean]

But the duplicated data is spread across two sheets rather than on one sheet. For example.

SHEET 1

33
44
66
77
88
99

SHEET 2

33
44


I want sheet 1 to recognise what is already on sheet 2 and remove them so that it will then read


SHEET 1

66
77
88
99

[AB33]

It could be done by a macro(Code). If you fancy one, please attach an excel workbook sample.

[hello its dean]

Cheers matey that would be grand.

[AB33]

There is a pinkie button on sheet1

[hello its dean]

That worked a treat, cheers matey

[sulbaran]

AB33

Can magic button be use in a list of names in different columns same sheet ? One column have a bunch of names and a second Column have also a bunch of names but some on the first colum are not listed in the second one?
Thanks
Felipe