A B C…..col
Car** 37 100
Van**
Bike 60
Plan** 3
Train

Hi all, I have above data in Sheet1. In above data in cell "C1" I
have fromula "=SUM(B1:B5)" which actually shows total of figures in
column B. I want some macro in Worksheet module which show a Message
Box only if cell "C1" have total amount 100 and if there is any figure
or amount been put by user in column B cell which is next to the text
of column A got ** in the end. For example looking at above data
there are amounts next to the text "Car**" and "Plan**" and as these
text got "**" in the end and total in cell "C1" is also 100 so message
box should pop up saying

As you have put amount next to the:
Car**
Plan**
Please go to Sheet2

and as soon as user click on "OK" on Message Box macro should select
Sheet2
Please can any friend help me on this