Hallo,
I am a very junior user.. so bear with me :O)

I need to do the following:

* In sheet 1, I have list of names, and in sheet 2 I have the same list of
names plus data regarding total revenue generated
* In sheet 1 I need to copy the total revenue generated, taking it from
sheet 2, through autofill. So it should look for the name match, copy the
relevant data on same row, and paste it in sheet 1

I hope this is clear...

thanks for your help in advance,
S