I get confused with deeply nested If/Then's inside a For/Next loop, so I've started using Goto's for readability

I think this is your logic in the macro, but it might not be what you wanted to do

I didn't want to go all the way down Column A



Option Explicit
Public Function FileFolderExists(strFullPath As String) As Boolean
     'Author       : Ken Puls (www.excelguru.ca[/URL])
     'Macro Purpose: Check if a file or folder exists
    On Error GoTo EarlyExit
    If Not Dir(strFullPath, vbDirectory) = vbNullString Then FileFolderExists = True
EarlyExit:
    On Error GoTo 0
End Function

Sub test()

With Sheets("Products")
    For Each cell In .Cells(1, 1).CurrentRegion.Columns(1).Cells
        If Len(Trim(cell.Value)) = 0 Then GoTo GetNextOne
        If cell.Value = "Misc. BOL" Then GoTo GetNextOne
        If cell.Value = "ProductName" Then GoTo GetNextOne
        If FileFolderExists("C:BOLData\DataStorage\" & cell.Value & "InvBkupData.xlsx") Then GoTo GetNextOne
        
        Workbooks.Add.SaveAs ("C:BOLData\DataStorage\" & cell.Value & "InvBkupData.xlsx")
        Workbooks(cell.Value & "InvBkupData.xlsx").Close
        MsgBox ("I've Created Workbook C:BOLData\DataStorage\" & cell.Value & "InvBkupData.xlsx")

GetNextOne:
    Next
End With
End Sub