I have a spreadsheet that I'm keeping track of daily events. Column "A" has a
list
of the diferent events and the columns to the right "b,c,d,e,f,...." are
labled with the
dates of the year. It takes quite some time to manually search for each
event in the "A" column , then locate the column labeled with todays date and
enter the
number of times the event was seen. I need a way to automaticlly have this
data entered.

I recieve these counts in a text message so I've been copying the counts
onto a seperate excel sheet, but I haven't been able to take the data from
the scratch
excel sheet and plug the information into the official spreadsheet.

One other little item, I have 150 events I keep track of but I never have
all 150
items reporting event's. SO this program needs to be able to look at the new
data
determine the event name , find the cell on the actual spreadsheet with the
same
event name and then add the count in the column with the current date.


HELP!