filter

[ericlch16]

i have two sheets

sheet 2 is linked to sheet 1 and both have values in column A

1
2
3
0
5

I sort column A and filter out amount 0 so that sheet 2 becomes

1
2
3
5


now when i update sheet 1 with

1
2
3
0
5
6

sheet 2 becomes as below because of the already filter property
1
2
3
5

the 6 is missing. can this filter be refreshed so that it only filter out 0? sheet 2 should become automatically when sheet 1 is refreshed. it should be

1
2
3
5
6
with the hiding

 

[Datsmart]

How is Sheet2 linked to Sheet1?
Are you using formulas in Sheet2 cells or something different?

It sounds like Sheet2 cell A6 is not linked to Sheet1 cell A6.
If it is, you should have a value on A6 in sheet2.