Hi All,

I am having some difficulties on the task.
I am suppose to allow the users to search a data, including wildcard and then it should gather all the values which matches the wildcard and sum it.
Eg:
A B
1 Name Value
2 Eddy 1.5
3 George 2.3
4 Max 1.0
5 Eddy01 3.5
6 Eddy02 2.2

So, there will be a msg box to ask the user to input the name. When the user input the value like Eddy*, the excel should be able to recognized the wildcard and sum the value (1.5+3.5+2.2) and send out the output as 7.2

Any idea how to make this work?

Thanks.