Hi,
I'm not sure if there is already a thread with this question.

I have worksheets 'INPUT' and then number of other worksheets which relates to 'COUNTRY', 'BUSINESS GROUP', etc.

I need help to create macro that would find a value in a column and copy the whole row, or selected cells into the worksheet that matches the value on the column's cell.

For example, in column D - 'country', find France, then copy cells into FRANCE worksheet?

Thank you