Thread: Need help with formula or macro to 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.

To complicate things, most people here are using Excel 2008 for Mac. However, if a macro is needed to automatically populate the data of projects for each locale onto each locale's log sheet, several people here have a PC and could be responsible for maintaining this sheet. So if a macro is needed to do this, okay. But if it can be done with just a formula, even better.

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 Leith Ross

Hello leveleyed,

A VBA macro is not an option if you have MACs running Office 2008, as VBA is not supported. You will have to use worksheet formulas and perhaps pivot tables.

Yes I know this. But can anyone explain how to do it using formulas or pivot tables?