Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vba searching for strings in multiple worksheets
Hi,
I am trying to search multiple worksheets for the word "Fail" and then copy all of the "fail" data that has a failure into another worksheet. I am able to copy one sheet to another, but cannot figure out how to search multiple sheets. The number of worksheets are dynamic. The user can add sheets to the workbook. Here is my working code for one sheet: With Sheet2 For i = 1 To .UsedRange.Rows.Count If .Cells(i, 1) = "Fail" Then 'Offset to select the testcase number Sheet1.Cells(j, 3) = Sheet2.Cells(i, 2) 'Offset to select the Serial Number Sheet1.Cells(j, 2) = Sheet2.Cells(i, 4) j = j + 1 Else Sheet1.range("B15:c500") = "" End If Next End With Thank you |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
vba searching for strings in multiple worksheets
Hi Justin See attached document every "Fail" should be stored in worksheet "Fail_Workbook" Thanks Denis +-------------------------------------------------------------------+ |Filename: Book2.zip | |Download: http://www.excelforum.com/attachment.php?postid=5108 | +-------------------------------------------------------------------+ -- jetted ------------------------------------------------------------------------ jetted's Profile: http://www.excelforum.com/member.php...o&userid=17532 View this thread: http://www.excelforum.com/showthread...hreadid=565152 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search in Multiple Worksheets | Excel Discussion (Misc queries) | |||
SUMif or SUMproduct across multiple worksheets? | Excel Worksheet Functions | |||
Line chart from multiple worksheets | Charts and Charting in Excel | |||
Update multiple worksheets | Excel Discussion (Misc queries) | |||
Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions |