Hi,
I have a spreadsheet with around 200 sheets in, each sheet has a name containing a policy number and there is normally another small part such as 01-000. I have the following code:
Sub FindPolicy()
Dim SearchData As String
SearchData = InputBox("Enter policy number here")
If SearchData...