Interactive table

[Dewdrop]

Dear Excel Experts,

I would like to have an interactive kind of table. When I made a selection, the summary table will show the performance from the table selected. Please see the table enclosed.

Grateful you could show me how.

Thank you.
dewdrop

[Richard Buttrey]

Before spending time with your existing data, which does not lend itself to straightforward functions (for instance your country sheets contain proper dates but your summay doesn't), can I suggest a much better layout for your data.

Put all the country information on one sheet with columns for

Date
Country
Type 'data here would be form a drop down and either Sales or COGS
Value

Your analysis is the simplified immeasurably with a Pivot Table.