Keeping one country from a sheet and deleting the rest

[mikelowski]

Hi you all,

Every quarter I receive an Excel file with lots of countries and several sheets with different variables being measured for each country company. What I'm supposed to do with it is to create an Excel file for every country. What I'm doing until now is just deleting it manually, which takes a lot of time.
I uploaded a simple example file. First sheet is the original output structure, usually coming with 20-25 sheets measuring different variables from several companies and countries. In the example, for the sake of simplicity, I just put two countries: the UK and France. Second sheet is what I need to produce, keeping only the UK and deleting France. Of course, I also have to do one file with only France.

I hope I've made myself clear so you can help me with this.

Thanks.

Example file

[Blokeman]

Cross-post;
http://stackoverflow.com/questions/2...eting-the-rest
http://www.mrexcel.com/forum/excel-q...ting-rest.html

Read this:http://www.excelguru.ca/content.php?184

[FDibbins]

Hi, welcome to teh forum

Please upload yout sample workbook to the forum, not all members are able - or willing - to access file hosting sites.

Having said that, is it really necessary to create new files for each country? Could you not just have each country on it's own sheet within the same file/workbook?

[mikelowski]

Yes, it doesn't matter if it's in the same workbook

[FDibbins]

OK then there are ways to extract from 1 sheet to another, based on criteria (country, in your case)

Upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[mikelowski]

Answer by a Reddit user:

Please Login or Register  to view this content.