Show only filtered information on Sheet2

[Consty1]

I have a list of teams in column A1:A20 on Sheet1. The same information is linked onto Sheet2 in the same cells. If I filtered Sheet1 for a particular team is it possible for only this filtered data to be visible on Sheet2?

Sample 11.xlsx

Thanks

[Fotis1991]

Perhaps this would be usefil for you.

http://www.excelforum.com/excel-tips...-formulas.html

[Consty1]

Thanks for the link. That works fine for the sample I attached (I posted a too simplistic sample, my fault) however I'm looking to filter the entire row on Sheet2 and not just the data in column A. Essentially if there's data placed alongside column A in sheet 2 this needs to be filtered along with column A.

[Fotis1991]

If you'll upload a small(using realistic data) worksheet, perhaps we'll be able to hlp you more.

[Consty1]

I'll see what I can come up with. To simplify if I could filter the rows in Sheet2 to exactly match the filtered row numbers in Sheet1 then that would work. Not sure if that's possible though.

[Consty1]

I'm struggling to come up with anything that realistically represents the size of the data that's present in the project I'm working on so I've updated the attached file in the op.

But essentially all I'm looking for is to be able to filter the first column in sheet1 and for the exact same numbered rows to be filtered on sheet2. So in the sample 11 attachment I've filtered for Team 2 in column A on sheet1. Rows 8 to 16 are now displayed and the data alongside them visible. On sheet2 I'm trying to filter the exact same rows 8 to 16 and for the corresponding data to filter alongside it. My actual project has up to a 100 columns of data so if I could just filter column A and get the entire row to change with it then that would be great.

[Fotis1991]

I just show to you my original suggestion, believing that ths should works for you.

[Consty1]

Yep you're right, that does indeed work, ty. Now I have the issue of getting conditional formatting to work with it.