Results 1 to 4 of 4

Searching workbook by staff member name

Threaded View

  1. #1
    Registered User
    Join Date
    09-26-2016
    Location
    Melbourne, Australia
    MS-Off Ver
    2007
    Posts
    2

    Searching workbook by staff member name

    Hi all,

    I have a portfolio manager document that I have created (attached HERE).

    It currently has an automated index and search box where you can search that index of worksheet titles.

    I would like to have an additional search box where you can search by the staff member assigned to the worksheet, ie you type in their name and an indexed list filters to the projects that they are leading. The staff member's name exists in cell F4 of each worksheet.

    Can anyone help me with a way to search by staff member in F4?

    Many thanks,

    Matt
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Count the number of staff working between times based on staff position
    By sparky1978 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-03-2016, 08:10 AM
  2. Return Staff Member who Held Position X at Store Y at Date Z
    By hwatson86 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-16-2016, 04:44 PM
  3. [SOLVED] Macro to update Score Card Summary when the new staff add-in or existing staff deleted
    By Faridwahidi in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-12-2014, 02:43 PM
  4. Calculate Leave Accural In a year using staff member tennur
    By SalientAnimal in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-03-2014, 06:54 AM
  5. Staff Planner - How To Set Up UserForm to Generate Data into Staff & Date Spreadsheet
    By Marie Snell in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-19-2013, 11:04 PM
  6. Replies: 2
    Last Post: 09-15-2013, 03:52 PM
  7. Which staff member has the most sales in this month?
    By shazzm in forum Excel General
    Replies: 2
    Last Post: 04-28-2011, 03:46 AM

Tags for this Thread

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