Excel Macro help! : tab identifier

• • Reply

  14 years ago

  by bird boyee

  birdboyee

  , United States

  Joined 14 years ago
  Hello! I need help in creating a macro! I have an excel spreadsheet with various worksheets, each worksheet is named different according to tests that must be performed. Each test is different and inputed 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" throughout all the tabs. I want to create a tab which will identify and display all the "failed", and "user issues" on one tab, and sort it according to its tabbed test 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 sum it up, I want to create a sheet that'll identify all the issues existing throughout tabs. Please email me at [email protected], thanks!
  
  
  
  
  Report abuse