Deleting duplicated data.....

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

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

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

Cheers matey that would be grand.

There is a pinkie button on sheet1

That worked a treat, cheers matey

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