1. try recording a macro with the filter on the country to get the items you
want and then maybe you can modify the vba  code to exactly suite your needs.

2. try recording a macro where you use find to actuallly find a country and then
use offet function to move the activecell to copy the contents

as i said i am not a VBA expert but this si what i would try..Crude but
recording and mdifying the macros have worked on innumerable occasions for me..