hi everyone.
I have some records with different data.
Now let's assume that as time goes by, some of these should be
considered in my analysis and some not. And this is something that
might change again.
So I put a format check that if selected makes that record "Active". I
use it for all my sums and calculations.
Now, what if -in another worksheet or another section of the same
worksheet- I want to create a list of the active records only?
First thing that came to my mind, use conditional formatting. Mmmmmm

Second thought: nested IF. Something like: if first record is not
active, then check the second, then the third, if active: copy here
But I thought this would create a problem in the second line below,
because besides the nested If I should also use some instruction
preventing copying twice the same active record. So I thing it would
be a mess.

Basically, what I'd like to have is a dynamic list of the active
records, something changing when I activate/deactivate my records.
Is that possible?
hope my question is clear

thanks a lot in advance