VBA name already searched

Squishy

To do that (rather than delete the found sheet, as in the current version of the file), the sheet test needs to be done first I think (as in the code extract below).

Here the loop of worksheets is modified so if a match is made, that sheet is displayed and a message box asks if that sheet needs replacing. If not, the macro is quit. If so, the sheet is deleted and the macro continues with the search.

I've added a message at the end (so the user knows something happens (it can be very quick with small files):

Sub Search_Separate_Workbooks()

Dim wbMaster As Workbook
Dim wbSlave As Workbook
Dim filePicker As FileDialog
Dim ws As Worksheet, wbReport As Worksheet, ReportNm As String

On Error Resume Next
ReportNm = Worksheets("Dashboard").Range("F6")

'check for any sheet with same search name

For Each ws In ThisWorkbook.Sheets
    If ws.Name = ReportNm Then
        ws.Activate ' show the sheet if found
        r = MsgBox("Want to replace this result?", vbYesNo, "A sheet with that name exists...")
        If r = vbNo Then ' leave if user wants sheet
            Application.DisplayAlerts = True
            Exit Sub
        End If
' delete so new sheet can replace it
        Application.DisplayAlerts = False 'prevent creation alert
        ws.Delete
        Application.DisplayAlerts = True
    End If
Next ws
.

.

.
Application.ScreenUpdating = True

MsgBox "Created new sheet: " & ReportNm

End Sub

Hope this fixes things for you.