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
Bookmarks