data entry problems
 

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!

data entry problems
 

Do yourself a favor and restructure your data.

You need three columns:
Event
Date
Count

Every time a new piece of data comes in, add it to the end of your list.
When you need a report, use the data to generate a PivotTable.

Your life will be much easier. Mistakes will be far fewer. It just takes a
little time to convert your current spreadsheet into the proper structure



"qlueless" wrote:

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!

data entry problems
 

I need show monthly totals per each event and i also need the average count on
any given day of the week per event.

Can a pivot table do these things?

"Duke Carey" wrote:

Do yourself a favor and restructure your data.

You need three columns:
Event
Date
Count

Every time a new piece of data comes in, add it to the end of your list.
When you need a report, use the data to generate a PivotTable.

Your life will be much easier. Mistakes will be far fewer. It just takes a
little time to convert your current spreadsheet into the proper structure



"qlueless" wrote:

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!

data entry problems
 

Yup! And so much more

"qlueless" wrote:

I need show monthly totals per each event and i also need the average count on
any given day of the week per event.

Can a pivot table do these things?

"Duke Carey" wrote:

Do yourself a favor and restructure your data.

You need three columns:
Event
Date
Count

Every time a new piece of data comes in, add it to the end of your list.
When you need a report, use the data to generate a PivotTable.

Your life will be much easier. Mistakes will be far fewer. It just takes a
little time to convert your current spreadsheet into the proper structure



"qlueless" wrote:

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!

data entry problems
 

Thanks, it appears to do what I wanted.

"Duke Carey" wrote:

Yup! And so much more

"qlueless" wrote:

I need show monthly totals per each event and i also need the average count on
any given day of the week per event.

Can a pivot table do these things?

"Duke Carey" wrote:

Do yourself a favor and restructure your data.

You need three columns:
Event
Date
Count

Every time a new piece of data comes in, add it to the end of your list.
When you need a report, use the data to generate a PivotTable.

Your life will be much easier. Mistakes will be far fewer. It just takes a
little time to convert your current spreadsheet into the proper structure



"qlueless" wrote:

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!