Variable and constant question.

you could make the strings an array, and check if the cell is part of the array:

Please Login or Register  to view this content.

one way could be to declare strVar with concatenation of all the strings. and then Use instr to find the wsData.Cells(1,1) in it.
like

HTML Code: 

please confirm instr syntax. I am a bit unsure of it. But the concept would definitely work.

or you can split the "Vikas,Calvinle,Excelforum" to make it an array and the use match function to find the wsData.Cells(1,1).value

HTML Code: 

I hope this helps

You may try this:-
--> Use a helper column in the excel sheet say Column X where you could list all the strings or sentences.
for eg. you listed
X1= Client report
X2= Employer report
X3= Product price

and then use this column in the macro to be searched in for wsData.cells(1,1).value

like this

Please Login or Register  to view this content.

Try Columns("X") instead of Columns("X").value, if the later didn't worked.

this should work. you won't need to change macro every time as you could add or change values in the column X.