M
muchacho
I have so much data in one worksheet that I'm soon having to enter new
data onto a 2nd worksheet. Worksheet 1 has the AutoFilter enabled on
each column.
The question I have is this:
Is there a way I can enter new data into worksheet 2 and if I select to
filter out to a particular word in worksheet 1, it will also do the same
with worksheet 2.
For example, on worksheet 1 only show rows that have 'dog' in the 1st
column - and do the same automatically for worksheet 2 without the need
to click on worksheet 2 and do the AutoFilter on that.
data onto a 2nd worksheet. Worksheet 1 has the AutoFilter enabled on
each column.
The question I have is this:
Is there a way I can enter new data into worksheet 2 and if I select to
filter out to a particular word in worksheet 1, it will also do the same
with worksheet 2.
For example, on worksheet 1 only show rows that have 'dog' in the 1st
column - and do the same automatically for worksheet 2 without the need
to click on worksheet 2 and do the AutoFilter on that.