Hello all,

im new to this forum. here is my problem. Lets say i have entered following information in one tab, lets call " AMERICAN" . Column 1 is the list that i want to pick. For example now i have picked rows 1, 3, and 4. And anything that i have not selected will be hidden.

I want to copy this information into another tab, call it "CANADIAN", like the other one, if x is not selected, it will be hidden in the new tab too. Also when this AMERICAN is updated CANDIAN should be updated. Anything that is not selected will be hidden automatically. Can anyone help on this. Thank you so much in advance.


column 1 column 2 column 3 column 4
1 x apple califonia 2012
2 apple florida 2011
3 x orange california 2012
4 x grapes ontario 2009
5 grapes texas 2009