I have a list of numbers that is subtotaled using 109 as the function number.
ie:
A1,A2,A3,A4....on worksheet WK1
Each one of these cells has a number in it.

Each one of these cells is linked to another cell within a worksheet called
WK2
ie:
cell A20 =WK1!A1
cell B20 =WK1!A2
cell C20 =WK1!A3
cell D20 =WK1!A4

When I filter the list of numbers on worksheet WK1 , the result of the
filter is...
(I filtered out row # 3 )..

A1
A2
A4

Now this is where I am finding my problem.
The contents of cell C20 in worksheet WK2 does not appear, even though it is
linked to A3 in worksheet WK1.
When I filter "show all", then the contents of WK2!C20 magically appears.

Any ideas as to what I am doing wrong ?