Forum Discussion
How to lookup and pull data from multiple sheets
Hello! I need to pull a list of all staff that say that they need follow up training. Please help! Thanks! Here is the data I need to pull: Here is how the sheets are setup
According to the formula in this link you can pull all information to your follow up training sheet and then filter only those who say yes. This can be done with Office 365 or Excel for the web.
Combine data in multiple worksheets - Excel formula | Exceljet