How do I populate one sheet with data filtered from another?

Hello,

I have a project log sheet that has a list of data for each project, including the locale of each project. I also have a separate sheet for each locale that the data from the project log is currently being manually copied and pasted to every day. What I would like to do is modify the sheets for each locale to automatically list the data for every project for that locale listed in the project log.

I have created a sample workbook and attached it. Basically, the idea is to have the data in the locales column (filled green) of the project log sheet determine which of the sheets the data in the rest of the columns (headings filled red) for that row end up in.

If someone could please help me figure out how to do this, I would sincerely appreciate it. The boss is breathing down my neck for this and I can't figure it out LOL!

Thank you!

Originally Posted by contaminated

hi leveleyed Try this macro out

PERFECT! So it looks like every time this macro runs it will populate all the sheets with the projects for each corresponding locale. Now I just need to know how to make a button on a sheet that will run this macro. Is there an easy way to do that?

Actually, I just realized, there is one problem with this macro. Every time I run it, it adds everything to the sheets that was already in them, so it ends up creating duplicate entries on each sheet if the macro is run more than once. Is there a way to make it so that each time it is run it will just populate each sheet with anything that isn't already listed in them? That way, each time a batch of new projects is entered into the log, the macro can be run to update the log sheet for each locale with just the newly added projects. Maybe it would be as simple as making it delete all the previous data on each locale sheet before it does it's magic? Thanks!!!!