Results 1 to 17 of 17

Search multiple sheets, return entire rows under each sheet name

Threaded View

  1. #1
    Registered User
    Join Date
    01-06-2020
    Location
    Adelaide, South Australia
    MS-Off Ver
    Excel Business 2016
    Posts
    10

    Search multiple sheets, return entire rows under each sheet name

    Hi clever peeps

    MANY years ago I was able to write basic VBA, create forms etc, but recent attempts over some largely unproductive hours pretty much tells me I have lost that ability - too long between drinks - so I'm asking for your help.

    I have a workbook that has a sheet for each active project (around 10-15 projects at any one time). On each project sheet, there are running lists of tasks with each task assigned to one of our workers.

    I want to be able to create a separate list of all tasks assigned to a selected worker (on the 'Your Tasks' sheet). The list is to include the whole row of data for the task.

    So, I wish to:
    1. Nominate the search value - worker's initials, currently entered via a simple data validation list (e.g. "AB")
    2. Check all project sheets for this value, searching in only Column A of each sheet
    3. With each successful hit, I'd like two things to occur in the Your Tasks sheet:
    a. Insert the name of the sheet (project) in a new row (only once no mater how many hits on that sheet)
    b. Beneath the sheet name, return the entire row for each search hit for that project

    The ideal result would show the search term (worker's initials) in the data validation cell followed by each project name and the tasks within that project that are assigned to that worker
    Please see the attached data sample (simplified and confidentials removed)

    Any help welcomed.
    THANKS IN ADVANCE
    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. Search the value in multiple sheets and display the entire row of matched value in list bo
    By haridevadiga in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-26-2015, 08:08 AM
  2. Replies: 6
    Last Post: 01-13-2015, 12:35 PM
  3. Return entire rows from multiple sheets into one table
    By h_685 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-08-2014, 04:33 PM
  4. [SOLVED] I need to search for a word on multiple sheets and copy the entire row to a new sheet
    By jkm750 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-26-2013, 12:13 AM
  5. Search value in multiple sheets and return sheet name(s)
    By evolv12 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-07-2013, 02:11 PM
  6. [SOLVED] Search multiple sheets for criteria and paste all matched rows in new sheet
    By BertLady56 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-14-2012, 01:09 PM
  7. Search for Multiple String Values on Multiple Sheets and Copy Rows to New Sheet
    By rrtikker in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-15-2012, 12:21 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