search table for unique values return values and corresponding cells to a different sheet

Hi guys - I have been dabbling with vba for a little while now and normally I manage to find the answer pretty easily but with this one I am struggling (also been googling for days)

so in my datasheet I have a table in the following format

a b c d e f g
1 aa ab ac af aa af 01/02/2016
2 aa bb ff fc aa ff 13/05/2016
3 gg ff aa af aa ff 17/11/2016

(don't shout at me I haven't worked out how to put it in properly yet)

A1:F3 contain a varity of codes, (aa,ab, etc) and column G contains a date.

I need a way to get the first instance of each unique value along with the corresponding date in a list on a different sheet (reportsheet2)

hopefully looking something like this

a b
1 aa 01/02/2016
2 ab 01/02/2016
3 ac 01/02/2016
4 af 01/02/2016
5 bb 13/05/2016
6 ff 13/05/2016



there is wayyyyyy more data than I have provided in this example just as a heads up

I do have a little bit of code that has arranged the rows into date order but other than that I am stuck,


any help would be greatly apreciated,

Kind regards,

T

thanks,

Why doesn't it like the first bit

Please Login or Register  to view this content.

and guessing I add this for all Columns?

Kind regards,

T