I have about 15 different workbooks that I work with. Each has a summary tab and 10+ detail tabs. I would like to create a new workbook that pulls info from all of the summary tabs, however, I only want it to pull the info if the "Conclusion" column from the summary tabs has either "Fail" or "Unable to perform" (basically I want a spreadsheet showing me what tests failed/could not be performed from the 15 workbooks). I know how to pull and link all of the info into a new workbook, which I have already done, but I don't know how to limit it to only pull the fail/unable to perform info . Any ideas?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Pulling data into a new workbook...
- Thread starter jdizzle24
- Start date
Similar threads
- Solved
