Dashboard

I have an excel sheet that contains that data which are rows and columns with text values.
for ex:

Date PR no Desc
09/09/2010 1111 test mesaage
08/09/2010 121212 testes
09/09/2010 232323 test mesaage

I want extract the data only for particular day for ex : 09/09/2010 and display those details in another xl sheet of same workbook.
it should be like this
Date PR no Desc
09/09/2010 1111 test mesaage
09/09/2010 232323 test mesaage


can any expert help me achieve this.

Hi sharugan,

and welcome to the forum,

You need to read about Tables and Filters in Excel and your problem should get easier. An AutoFilter would be the easiest but if you need it on another sheet you might need Advanced Filters.

You might also read the forum rules and change your title to a question or more specific problem.

A text file is recommended for more specific suggestions. Click on "Go Advanced" to get more option icons and upload a file if the above suggestion doesn't help.