bring 'in progress' tasks to front worksheet

[Nikki]

Hi,

Is there a way to bring only certain cells to the front worksheet depending
on the text in a certain other cell?

I have one worksheet that has all the information about jobs to track. on
the front worksheet of that workbook I would like to show just those jobs
that are still in process or require action. Is there a way to do this?

Thanks

 

[jpdphd]

Hi,

Is there a way to bring only certain cells to the front worksheet depending
on the text in a certain other cell?

I have one worksheet that has all the information about jobs to track. on
the front worksheet of that workbook I would like to show just those jobs
that are still in process or require action. Is there a way to do this?

Thanks

Nikki,
You could use a filter (Data > FIlter).
The filter could even be on the original worksheet - no need for a
"front" one, but that would be ok too.
If you need details, just ask.
jpdphd