Hello,
I have searched the forums and not sure that I've found what I need--so here I am asking:
I manage a schedule in Excel with a bunch of different dates for marketing programs, when they are upcoming they are in red, when they are running they are green, and when they have ended they are grey. I want to have an additional sheet that pulls up all upcoming programs to make it easier to prioritize.
I am attaching an example below, but for the privacy of my clients I am replacing names/programs with nonsense text. What really matters is the dates..
So, as seen below, the gray has passed, the green is in progress, and the red item 7 has yet to be completed. My optimal outcome is a second sheet in this example is a sheet with item 7 only, but then removes it when I recolor the cells to green. Is this possible?
Btw, I have about 10 pages of this info.. if not I would just cut and paste
I have searched the forums and not sure that I've found what I need--so here I am asking:
I manage a schedule in Excel with a bunch of different dates for marketing programs, when they are upcoming they are in red, when they are running they are green, and when they have ended they are grey. I want to have an additional sheet that pulls up all upcoming programs to make it easier to prioritize.
I am attaching an example below, but for the privacy of my clients I am replacing names/programs with nonsense text. What really matters is the dates..
So, as seen below, the gray has passed, the green is in progress, and the red item 7 has yet to be completed. My optimal outcome is a second sheet in this example is a sheet with item 7 only, but then removes it when I recolor the cells to green. Is this possible?
Btw, I have about 10 pages of this info.. if not I would just cut and paste