Data Counter via InputBox

I would like to set up a counter for some of my data.

So,there would be certain amount of data entries already typed in in sheet over a 4,5 columns.
A certain cell(adjacent one) would be assigned as a 'counter' cell.
So,if B1 contains Data,then B2 would be a cell which would contain a counter number.

The counting would be performed via InputBox.
Entries would be "case free",so "4evra" would be equal to "4EVRA"

I click a button,InputBox runs,in it i enter "4evra"
If there is an entry in any of the columns in that sheet,a "counter" cell(cell that is column+1 away from entry) would get a +1 to its value.
Starting value would be a 1 offcourse.
If the word inputed does not not exist as an entry in excel,the input box would return an error or a notification about it,but it wouldn't create new entry.

A similar code was provided to me earlier by a kind member of forum,but,i just cant grasp some code lines in it,like how does it manages to do increments on counter values,so i can't modify it alone.
Here is the link to that code: http://www.excelforum.com/excel-prog...e-entered.html

Catching up:
I didn't get where the data is as you said, 4-5 columns, could you upload a sample workbook?
and try this:

Please Login or Register  to view this content.

Hi,
Counter.xlsm
I changed it to simpler code:

Please Login or Register  to view this content.