Combining multiple sheets

[Mr Frosty]

<TABLE style="WIDTH: 179pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=239><COLGROUP><COL style="WIDTH: 179pt; mso-width-source: userset; mso-width-alt: 8740" width=239><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 179pt; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=17 width=239>Mr Frosty</TD></TR></TBODY></TABLE>

I'm looking to combine three regional sales fcst files into one report.

Each region will have multiple sheets - one for each country. Same columns and basic data elements.

What's the best way to create a dynamic summary for each region and then one for all the regions together?

Thanks

 

[wigi]

Hello

Use a database kind of structure in 1 sheet. With a column for the country, and if wanted another column for the region.

Once this is done, insert a Pivot table and you can filter on individual countries, or rather show the total. All in a matter of mouse clicks.

 

[Mr Frosty]

Thanks very much - Let me give it a try