I want to display all rows that has Gender column equal to `M` inside `sheet2`. The data is retrieved from `sheet1`. The filtered data also has to be real time, meaning whenever I make change in gender column in `sheet1`, `sheet2` data should also change accordingly. How could I achieve this?
sheet 1
sheet1.PNG
sheet 2
sheet2.PNG
Bookmarks