search table for unique values, return value and corresponding cell to another 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!! I will give it a go

That works a treat!!!!

how would I do it if I wanted to return row g and h?

I tried

but I feel like this was a total newbie mistake...

Please Login or Register  to view this content.

Thanks

T

the sheet with the data on is on another sheet (sheet19) and I want to click a button on reportsheet 2 and get the list on report sheet 2

I have solved the above issue by combining the two columns G and H in column I and using that instead of just G

Thanks,

T

it also comes up with type mismatch for i and j??

ahh Cool!!

Thanks so much!

Great solution

why is it returning a type mismatch for Ubound(Vdata,1)?

it doesn't start in Cell A1 it starts in E1 I did change it to E1 in that line but it still said type missmatch

Thanks

T

cool thanks!

Good i am like it