I know this post is old and you have helped me a lot, but I have one more question.

I am back to working with Department Updates and Announcements.xlsx again and I was wondering if it is possible to eliminate the "all" tab and incorporate the updates flagged as all into every department sheet so that whether flagged as "claims" or "All" it still populates on the claims sheet? maintaining the same functionality of the manager announcements as well of course.


Thanks again!

PS I promise to flag this thread as solved after this haha!