+ Reply to Thread
Results 1 to 2 of 2

Dashboard

  1. #1
    Registered User
    Join Date
    09-11-2010
    Location
    reading
    MS-Off Ver
    Excel 2003
    Posts
    1

    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.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,275

    Re: Expert help on Excel Dashboard

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1