Hi,

On Worksheet A - I have 100 rows. I want to copy those set of rows to
another worksheet (b) and then filter it. So if data is entered in worksheet
A, then when I switch to worksheet B , if the new data matches the filter
criteria it is displayed.

the end result would be worksheet A contains unfiltered rows and worksheet B
contains filtered rows.

Thanks Rob