Search cell in rows and copy paste

[nicolaforni]

Hi,

I have following data in Sheet2 in column A to C (starting A1):

Apples France 100
Pears Italy 50
Bananas Guatemala 20
Kiwis New Zealand 60
Grapes Spain 10
Figs Italy 80
Melon Italy 20


I would like to do a search through column B and if Italy is found then if number is higher than 50 (in column C) I would like the text in column A to be copied in Sheet1 starting from Cell A1 going down.

Thanks,
Nix

[davegugg]

Please Login or Register  to view this content.

[nicolaforni]

Great.
How would the code change if instead of looking for "Italy" I wanted to look for what is in cell E1 of Sheet1?
Basically this way I could change search by typing different country in E1 (eg. France, Spain etc.) instead of amending code each time.

Thanks,
NIc

[davegugg]

Please Login or Register  to view this content.

[nicolaforni]

Thanks!