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!
Bookmarks