Excel search - Display a third column in the results

[johnrrinc]

Can anyone help me modify this file so that when searching for a zip against all the worksheets it also displays in the results the data from Column 'C' in the worksheets.

In other words, under the search worksheet I should see the results as 'School', 'Campus' & 'Notes'

I can't seem to figure out how to include that additional column. Any help with this is highly appreciated.

rr_zip_search.xlsm


Thank you

[martindwilson]

change this bit

Do Until FoundCell Is Nothing
                    With Worksheets(shSearch).Cells(Rows.Count, "f").End(xlUp)
                        .Offset(1) = ws.Name
                        .Offset(1, 1) = FoundCell.Offset(0, -1)
                        .Offset(1, 2) = FoundCell.Offset(0, 1)
                        .Offset(1, 3) = FoundCell.Row
                        
                    End With

[johnrrinc]

Works like a charm! Thank you sir.

[johnrrinc]

oh just one more thing I noticed...After making this modification the results display just as expected. I'm able to search a zip code however if I try to run a new search it does not clear the previous results. why is that?

rr_zip_search.xlsm

[martindwilson]

id just change this bit

 With Worksheets(shSearch)
        .Range("f2:i2000").ClearContents
        SearchTerm = .Range("b3")
        
    End With

[johnrrinc]

Yep. that worked. Thank you