Filter Data

[imran ashraf]

I have data from column A to J and there is ID number in column B .so on top of the sheet i want when i put the id number in Cell the data should show me regarding that id from column A to J on same sheet.

ID

123

<tbody>
</tbody>

A	B	C	D	J
Date	ID	Data1	Data2	Data3

<tbody>
</tbody>

...Many Thanks

 

[SpillerBD]

What version are you using?

I would suggest using Table and Table Slicer if you have 2013 or later.