+ Reply to Thread
Results 1 to 4 of 4

Formula to search for and filter data

  1. #1
    Registered User
    Join Date
    09-03-2013
    Location
    Belfast
    MS-Off Ver
    Excel 2003
    Posts
    2

    Formula to search for and filter data

    Hi,

    I have an excel sheet with several tabs across the bottom, each tab is of a specific area. Within each area there are several jobs of which are completed by workers.

    I would like to add a few more tabs however id like the tabs to be of each worker. So I am after an equation that will search through the other entire tabs looking for this worker name and filtering back into the worker tab:

    Area 1
    Job Nr Worker Rd Name Status Date
    1 AA Rd 1 Finished 02/02/13
    2 AB Rd 2 Finished 10/03/13
    3 AA Rd 3 Pending 03/09/13

    Area 2
    Job Nr Worker Rd Name Status Date
    1 AB Rd 1 Pending 03/09/13
    2 AB Rd 2 Finished 08/08/13
    3 AC Rd 3 Finished 07/05/13

    AB
    Area Nr Job Nr Rd Name Status Date
    1 2 Rd 2 Finished 10/03/13
    2 1 Rd 1 Pending 03/09/13
    2 2 Rd 2 Finished 08/08/13


    I hoped I explained this well enough for someone to help out!

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Formula to search for and filter data

    Hi and welcome to the forum.

    Be sure that best way to describe your problem is to upload a sample workbook.

    Be sure that all sensitive data removed, showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that.

    To attach a small sample workbook.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    09-03-2013
    Location
    Belfast
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Formula to search for and filter data

    Example.xls

    Thanks for the help.

    Ive included a small workbook! hopefully someone is able to help, Id like all the jobs that AB has completed in all area into the AB tab!

  4. #4
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Formula to search for and filter data

    So you need multiply results for a worker in multiply sheets....

    This will be hard to do...

    My suggestion for this is to use VBA OR to use a sheet for all your Area and then quite easily to create many sheets for eatch worker.

    Good luck.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Create Search form to filter data on another tab
    By bigroo1958 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-22-2012, 05:35 PM
  2. Search Table - Advanced Filter/Data Validation?
    By EmilyB in forum Excel General
    Replies: 1
    Last Post: 01-12-2011, 01:35 AM
  3. filter data, nested search
    By gdallas in forum Excel General
    Replies: 8
    Last Post: 02-16-2010, 12:30 PM
  4. Data search / filter all worksheets
    By airpix in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-12-2008, 12:27 AM
  5. [SOLVED] Can one sort, filter or search for data that is marked with a particular colour?
    By colincurious@hotmail.com in forum Excel General
    Replies: 1
    Last Post: 02-03-2006, 12:55 PM

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