IF with PIVOT (I want to copy some of the table to the other sheet in excel)

Hi there,

I have table in an excel spreadsheet that I would like to take some informations to the other sheet.

I am not sure if I could upload the sample file ,so I did summarize my excel table above. IF I could manage the upload , please take a look at it

In the table;
Bcoloumn is "Country" H "products interested"
C is "adress" I "notes"
D is "firm" J "action"
E is "telephone number"
F is "e-mail"
G "scope of activity" ,


SO here the question.. I would like to take "country" "firm" "e-mail" sections to the other sheet IF ACTION PART IS "MAIL SENT" !!

And I am assuming that I could solve this with Pivot table so thats why the title is Pivot

Many thanks!!

Originally Posted by avk

Refer attach file.
If mail sent then data extract to another sheet.
using index,small,row formula.

Hello,
Thank you for your answer, that helped.