Update filtered values in another sheet

[coco-cosmin]

Hi all! I have the following problem which I don't know how to solve:
- In one sheet I have the "Name of the Country" field which contains different countries. Also I have other fields like Company, Sales $ etc
- I want to show in another sheet the amount of sales done for each country, but I want to be able to show it only for the selected Country. Can you please help me?

[newdoverman]

Welcome to ExcelForum.

In order to help you better, it would be helpful to upload a workbook with representative data. Here are some directions.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[coco-cosmin]

Dear All,
I have attached a document on which I hope I can better explain what I need. In the "New Table" I want to show only the values for the filtered countries from the "Main Table". For example if in the Main table I will filter for France, the same values should be shown also in the New Table. Thank you!