Macro help

Hi

I am wondering if somone could help me with some macros in excell 2003. They should be pretty basic, so any help would be great. I have a colum with 3 letter codes that may be repeated throughout the column. I was wanting a macro to copy this column to another sheet but only list the codes once (i.e. so that code is unique in the new column)

I was wanting to print fields only if one cell (the total of each field) is not zero (i.e. so that the the only fields printed are ones with inputs)

The last one is a macro that only prints rows whick have a specific value in a column of that row.

Thanks for the help,

G