Hello,

I have two excel worksheets, one for overall country reviews which has all the information about different countries and their comments on different products they use ( master sheet) and the other sheets for individual countries respectively.

Basically I want

to automatically update the individual country review worksheet ( detail sheet) whenever the review comments in the master one for that particular country has been changed.

suppose for example ,I have 20 rows for UK as country in master sheet , I want the individual country review sheet UK to get updated with that information.is it possible? I know how to link two sheets but dont know how to filter them by a column and use it .


Basically we need this functionality to show the individual country their product and performance and not show the information about all countries. Their are hundreds of records in the master table hence the requirement.

Please help me.
Regards,
Anchal.