Hello! I need help in creating a macro!
I have an excel spreadsheet with various tabs, each tab is named different according to tests that must be performed. Each test is different and logged by rows, there is one column from each test in which we populate passed, failed, pending, N/A, or user issue.
The problem is searching for all the failed, and user issue's throught all the tabs
. I want to create a tab which will identify and display all the failed, and user issues on that one tab, and sort it according to tab name. Now, not to be picky, I would like to copy only a few cells along with the failed message, if not, the entire row would be fine. Could anyone assist?
To put it in a nut shell, I want to create a one place view of all issues throught the spreadsheet.
I have an excel spreadsheet with various tabs, each tab is named different according to tests that must be performed. Each test is different and logged by rows, there is one column from each test in which we populate passed, failed, pending, N/A, or user issue.The problem is searching for all the failed, and user issue's throught all the tabs
To put it in a nut shell, I want to create a one place view of all issues throught the spreadsheet.
Last edited: