Showing only multiple rows where column A = x

[SW1044]

Hi,

I have a spreadsheet with 4 digit numbers in column A and a text string in column B

I would like to hide all the rows except those where the value in column A matches the value in a certain cell (which the user will type in)

I know autofilter can do this but the data is confidential so the purpose is to rectrict access rather than just filter the data.

Rather like a Vlookup reading from a hidden sheet, but with the ability to return multiple rows.

Many thanks in advance for any suggestions!

Cheers, Scott.

 

[Yahya]

Hi
i think the best way to use Autofilter
or you can by formula to do it
see if this example will help you

Excel Workbook
	A	B	C	D	E	F	G
1	Code	Name		1114
2	1112	Yahya 1				Code	Name
3	1114	Yahya 2				1114	Yahya 2
4	1114	Yahya 3				1114	Yahya 3
5	1112	Yahya 4				1114	Yahya 6
6	1115	Yahya 5				1114	Yahya 8
7	1114	Yahya 6				1114	Yahya 10
8	1115	Yahya 7
9	1114	Yahya 8
10	1113	Yahya 9
11	1114	Yahya 10
12	1112	Yahya 11
13	1111	Yahya 12
14	1111	Yahya 13
15	1113	Yahya 14
16	1113	Yahya 15
17	1112	Yahya 16
Sheet6

Excel 2007

#VALUE!

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.

 

[SW1044]

Thanks, that's exactly what I need and I can modify it to cover other sheets.

Cheers!

 

[Yahya]

Thanks, that's exactly what I need and I can modify it to cover other sheets.

Cheers!

you are welcome