I have never written a Vba script. If there is a more appropriate forum for
me, please point me to it. If you are able to help here, please do so in
explicit step by step form. I found what appear to be answers on Google, ran
a simple macro, then tried to copy and paste the answers into my macro -
didn't work.

There are 2 problems, which (I think) are similar. They will be in different
workbooks and unrelated.

1) I have a column full of either "a" or "b". I want to find every "b" value
and delete the entire row it's in.

2) A workbook has names in one column, some of which are duplicated,
sometimes repeated 3 or 4 times. I want to retain the first row with each
name and delete rows with duplicates.

Any assistance is very much appreciated

Steve Wallis

(Change yahoo to bigpond)