Pulling a row of data from one sheet to another based on a column value

[caldepp]

Hi All,

Thanks in advance for your help.

I am creating a large task agenda (a to-do list on steroids) for a large team of individuals. This list will contain three columns: a person, a time and a task. I'd like to have a master sheet with every task regardless of individual or time, but I'd also like to have separate sheets into which data would automatically flow per person. For example, if on the task agenda, John Doe has 35 tasks distributed between a list of 500 tasks, I'd like to create a formula in a separate sheet that could pull each of John Doe's tasks paired with the times (columns 2 and 3) and consolidate them into a specialized, abbreviated list. And, again ideally, I'd hope that if I later added a new task for John Doe to the master sheet, the formula would behave in such a way that it would automatically flow to the new sheet. After experimenting, I'm not sure V-Lookup or INDEX-MATCH functions are the ticket here; maybe they are and I'm simply using them wrong.

Hopefully that makes sense. Any help here would be great.

Caleb

 

[Peter_SSs]

Welcome to the MrExcel board!

See if you can adapt this. If you need more help with it post back with more details of what you are getting stuck on.