Looking up a word in the data sheet and copying the entire row to a different sheet

[ismail000]

Hi Guys,

I am hoping to get help here,

My knowledge of VBA/Macros is very minimal so hoping you guys can assist.

Attached is an excel sheet which I use for reporting each month. Currently I filter according to country and copy and paste the entire countries data to the relevant sheet.

I would like a formula or VBA/Macro to assist with this. I will populate the Data sheet on a monthly basis and the workbook needs to automatically match the countries name and copy the entire row to the relevant sheet.

thanks in advance.

[nathansav]

Good place to start would be to record a macro with the cutting and pasting, then taking a look at the code.