Hi David
Hm, you only set the filter to column B.
I'm not sure if I understood everything, but as far as I see, you would be much better off applying the filter to all columns, and prefilter column A according to your selection in "Scorecard", instead of just hiding rows. For example it can easily be done to apply the filter to showing for all persons Goals and Tasks to Goal1.
That way, you then can do further filtering in "Tasks" according to names without worrying that hidden rows by the autofilter showing up.
From that you can even go a step further filling in the third column, and if necessary again filtering for "non-empty"...
You know what I mean?
To keep initially "manually" hidden rows hidden, won't allow you the use of the autofilter directly, but you will have to do all further "filtering" by vba, or via additional columns. But the setup will be quite a difficult one.
|