I have 2 ranges "SheetNames" starting in cell D7 - generated by the code below, and "OrgNames" starting in cell E7, that is input by a user . I want to generate a list starting in cell F7 containing values which are in OrgNames but not in SheetNames. There will always be values in SheetNames that do not occur in OrgNames. I'm sure this is probably quite simple to achieve but i'm stumped- any suggestions?....
Code:
Sub find_sheet_names()
Dim x As Integer
For x = 1 To Worksheets.Count
Cells(x + 7, 4).Value = Worksheets(x).Name
Next x
End Sub