Macro to display list of unique data from spreadsheet

Hi,

Im trying to get some info from a spreadsheet automatically using a macro but after 2 weeks i have to beg for help.

Im trying to display each unique reg number from col "reg" from cell t1 onwards. In cell t2 onwards i want to put the difference between the highest value in the "odo" column and the lowest for each reg.

any help or pointers would be a great help.

PC