Sorry for the longwinded title, So I've got say a table with country names all down column A and values in columns B-H. I want to to scan column A of Table2 to see if any country exists in table2 and table1 and if it does, cut that row A-H from table1 and paste in above table1.

Hope that makes sense

Cheers Guys,

Daryl