**
I dont know if this can be done in excel…**
Say I have a sheet with a list of jobs with details and a tick box to show when they are complete.
[COLOR=Blue]A. tick
B.
C. tick
D. tick
E.
F. tick[/COLOR]
I want to generate a report that only shows the completed jobs.
[COLOR=Blue]A. detals
C. detals
D. detals
F. details[/COLOR]
I know I could get it to show.
[COLOR=Blue] A. details
B.
C. details
D. details
E.
F. details[/COLOR]
But i really dont want blank rows of data in it…
I know how I would do it in a program
[COLOR=Blue]while (i <= F)
if (n = tick)
print (n)
n++
i++[/COLOR]
**but can you get excel to enter a loop like that ?
**
