Search results for query: *

Thank you!!!! It all works;-)

I did some more testing with the workbook I posted as I put some data in sheets 1-5; example if I search for "Reddy" I only get sheet1 results, but if I search for "Delucia" I get results from sheet1 and sheet5 (none from the sheet2, 3, 4). I did a search by serial number (A: all sheets) and...

I appreciate all the help; I copied the above and ran it... it still copies a row twice if the search criteria is listed in two different cells of the same row (I would like it to find the first occurrence, copy and move to the next row). It also now only checks the first sheet where it did the...

Thanks in advance; I made the changes (shown Below) and I get a Run-time error '91": Object variable or With block variable not set. I left fake data on sheet 1 if you wanted to test by searching by any field on the search tab. Sub FindText() Dim ws As Worksheet, Found As Range Dim myText...

Sorry, as I stated I just picked this all up be reading previous posts and have no background in VBA. here is the code and link to the actual workbook: Sub FindText() Dim ws As Worksheet, Found As Range Dim myText As String, FirstAddress As String Dim AddressStr As String, foundNum As...

Hi, new to VBA, but I have a workbook with multiple sheets (same format). I have code (pulled from multiple sites) to search and copy the row of data if string is found and loop. The issue is that in some cases two fields (G: and K:) might have the same string and I only want to copy row once...