Filtering help

[PrinceExcel]

I am trying to create a filtering scenrio. Ex. The value of Sheet1 in cell A2 is username "Admin", if that happens all Username with admin in Sheet2 will be filtered from the table of raw data.

 

[Peter_SSs]

In Sheet2, what column would the "Admin" values appear in?

Is the "table of raw data" in Sheet2 just a normal range of data with a heading row or a formal Excel table (eg created via Insert -> table)?

Does cell A2 in Sheet1 get changed manually or does it contain a formula?

 

[PrinceExcel]

In Sheet2 admin would appear under USER column.

The raw data in sheet2 is normal range of data.

A2 in sheet1 has formula.

 

[Peter_SSs]

In Sheet2 admin would appear under USER column.

.. but I cannot see your Sheet2 so I still don't know which column that is (A, B, K, ..?)

The raw data in sheet2 is normal range of data.

OK, thanks.

A2 in sheet1 has formula.

What is the formula?