filtering and linking two separate worksheets together

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.

You could set this up a bit differently - rather than have one sheet per country, you could have a drop-down which allows you to select the country from a list, and then the display would immediately change to show only those records for that country.

You would still have to keep the Master sheet up-to-date, however, but the subsidiary sheet would always show the relevant data from the Master sheet.

Hope this helps.

Pete

Pete,

Thanks for the response, currently the country column is filtered as a list in the master table ,but still the respective country sheets need to be maintained separately since they would like to add some additional data into it ,basically master table with a filter in country could be saved as separate country list but they require it in separate worksheet , hence I am interested in linking these two by filtering , any update on master should reflect detail sheet any more ideas please..