+ Reply to Thread
Results 1 to 3 of 3

excel to automatically filter a table and display in different sheet

  1. #1
    Registered User
    Join Date
    03-05-2009
    Location
    new zealand
    MS-Off Ver
    Excel 2003
    Posts
    9

    excel to automatically filter a table and display in different sheet

    Hi

    I have a table of jobs and i would like to know how to run a macro so that excel automatically displays the jobs which are not complete in a seperate sheet. Which gives me the work in progress.

    The incomplete jobs are unmarked in the complete/incomplete column.

    Is it possible to do this?

    Any help would be greatly appreciated

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,363

    Re: excel to automatically filter a table and display in different sheet

    Hi,

    this sounds suitable for Advanced Filter. You find it in Data - Filter - Advanced Filter.
    The Excel Help Files have some good explanations on how it works.

    You basically have a few empty rows above your table, and enter your filter criteria into one of these empty cells. Depending on how the Advanced Filter is set up, your filtered list can appear in a separate sheet in the workbook.

    HTH

  3. #3
    Registered User
    Join Date
    03-05-2009
    Location
    new zealand
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: excel to automatically filter a table and display in different sheet

    thanks i will gie it a go

+ 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