software

I have a spreadsheet that I'm keeping track of daily events. Column quot;Aquot; has a
list
of the diferent events and the columns to the right quot;b,c,d,e,f,....quot; are
labled with the
dates of the year. It takes quite some time to manually search for each
event in the quot;Aquot; 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!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
quot;qluelessquot; wrote:

gt; I have a spreadsheet that I'm keeping track of daily events. Column quot;Aquot; has a
gt; list
gt; of the diferent events and the columns to the right quot;b,c,d,e,f,....quot; are
gt; labled with the
gt; dates of the year. It takes quite some time to manually search for each
gt; event in the quot;Aquot; column , then locate the column labeled with todays date and
gt; enter the
gt; number of times the event was seen. I need a way to automaticlly have this
gt; data entered.
gt;
gt; I recieve these counts in a text message so I've been copying the counts
gt; onto a seperate excel sheet, but I haven't been able to take the data from
gt; the scratch
gt; excel sheet and plug the information into the official spreadsheet.
gt;
gt; One other little item, I have 150 events I keep track of but I never have
gt; all 150
gt; items reporting event's. SO this program needs to be able to look at the new
gt; data
gt; determine the event name , find the cell on the actual spreadsheet with the
gt; same
gt; event name and then add the count in the column with the current date.
gt;
gt;
gt; HELP!
gt;

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?

quot;Duke Careyquot; wrote:

gt; Do yourself a favor and restructure your data.
gt;
gt; You need three columns:
gt; Event
gt; Date
gt; Count
gt;
gt; Every time a new piece of data comes in, add it to the end of your list.
gt; When you need a report, use the data to generate a PivotTable.
gt;
gt; Your life will be much easier. Mistakes will be far fewer. It just takes a
gt; little time to convert your current spreadsheet into the proper structure
gt;
gt;
gt;
gt; quot;qluelessquot; wrote:
gt;
gt; gt; I have a spreadsheet that I'm keeping track of daily events. Column quot;Aquot; has a
gt; gt; list
gt; gt; of the diferent events and the columns to the right quot;b,c,d,e,f,....quot; are
gt; gt; labled with the
gt; gt; dates of the year. It takes quite some time to manually search for each
gt; gt; event in the quot;Aquot; column , then locate the column labeled with todays date and
gt; gt; enter the
gt; gt; number of times the event was seen. I need a way to automaticlly have this
gt; gt; data entered.
gt; gt;
gt; gt; I recieve these counts in a text message so I've been copying the counts
gt; gt; onto a seperate excel sheet, but I haven't been able to take the data from
gt; gt; the scratch
gt; gt; excel sheet and plug the information into the official spreadsheet.
gt; gt;
gt; gt; One other little item, I have 150 events I keep track of but I never have
gt; gt; all 150
gt; gt; items reporting event's. SO this program needs to be able to look at the new
gt; gt; data
gt; gt; determine the event name , find the cell on the actual spreadsheet with the
gt; gt; same
gt; gt; event name and then add the count in the column with the current date.
gt; gt;
gt; gt;
gt; gt; HELP!
gt; gt;

Yup! And so much more

quot;qluelessquot; wrote:

gt; I need show monthly totals per each event and i also need the average count on
gt; any given day of the week per event.
gt;
gt; Can a pivot table do these things?
gt;
gt; quot;Duke Careyquot; wrote:
gt;
gt; gt; Do yourself a favor and restructure your data.
gt; gt;
gt; gt; You need three columns:
gt; gt; Event
gt; gt; Date
gt; gt; Count
gt; gt;
gt; gt; Every time a new piece of data comes in, add it to the end of your list.
gt; gt; When you need a report, use the data to generate a PivotTable.
gt; gt;
gt; gt; Your life will be much easier. Mistakes will be far fewer. It just takes a
gt; gt; little time to convert your current spreadsheet into the proper structure
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;qluelessquot; wrote:
gt; gt;
gt; gt; gt; I have a spreadsheet that I'm keeping track of daily events. Column quot;Aquot; has a
gt; gt; gt; list
gt; gt; gt; of the diferent events and the columns to the right quot;b,c,d,e,f,....quot; are
gt; gt; gt; labled with the
gt; gt; gt; dates of the year. It takes quite some time to manually search for each
gt; gt; gt; event in the quot;Aquot; column , then locate the column labeled with todays date and
gt; gt; gt; enter the
gt; gt; gt; number of times the event was seen. I need a way to automaticlly have this
gt; gt; gt; data entered.
gt; gt; gt;
gt; gt; gt; I recieve these counts in a text message so I've been copying the counts
gt; gt; gt; onto a seperate excel sheet, but I haven't been able to take the data from
gt; gt; gt; the scratch
gt; gt; gt; excel sheet and plug the information into the official spreadsheet.
gt; gt; gt;
gt; gt; gt; One other little item, I have 150 events I keep track of but I never have
gt; gt; gt; all 150
gt; gt; gt; items reporting event's. SO this program needs to be able to look at the new
gt; gt; gt; data
gt; gt; gt; determine the event name , find the cell on the actual spreadsheet with the
gt; gt; gt; same
gt; gt; gt; event name and then add the count in the column with the current date.
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; HELP!
gt; gt; gt;

Thanks, it appears to do what I wanted.

quot;Duke Careyquot; wrote:

gt; Yup! And so much more
gt;
gt; quot;qluelessquot; wrote:
gt;
gt; gt; I need show monthly totals per each event and i also need the average count on
gt; gt; any given day of the week per event.
gt; gt;
gt; gt; Can a pivot table do these things?
gt; gt;
gt; gt; quot;Duke Careyquot; wrote:
gt; gt;
gt; gt; gt; Do yourself a favor and restructure your data.
gt; gt; gt;
gt; gt; gt; You need three columns:
gt; gt; gt; Event
gt; gt; gt; Date
gt; gt; gt; Count
gt; gt; gt;
gt; gt; gt; Every time a new piece of data comes in, add it to the end of your list.
gt; gt; gt; When you need a report, use the data to generate a PivotTable.
gt; gt; gt;
gt; gt; gt; Your life will be much easier. Mistakes will be far fewer. It just takes a
gt; gt; gt; little time to convert your current spreadsheet into the proper structure
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;qluelessquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I have a spreadsheet that I'm keeping track of daily events. Column quot;Aquot; has a
gt; gt; gt; gt; list
gt; gt; gt; gt; of the diferent events and the columns to the right quot;b,c,d,e,f,....quot; are
gt; gt; gt; gt; labled with the
gt; gt; gt; gt; dates of the year. It takes quite some time to manually search for each
gt; gt; gt; gt; event in the quot;Aquot; column , then locate the column labeled with todays date and
gt; gt; gt; gt; enter the
gt; gt; gt; gt; number of times the event was seen. I need a way to automaticlly have this
gt; gt; gt; gt; data entered.
gt; gt; gt; gt;
gt; gt; gt; gt; I recieve these counts in a text message so I've been copying the counts
gt; gt; gt; gt; onto a seperate excel sheet, but I haven't been able to take the data from
gt; gt; gt; gt; the scratch
gt; gt; gt; gt; excel sheet and plug the information into the official spreadsheet.
gt; gt; gt; gt;
gt; gt; gt; gt; One other little item, I have 150 events I keep track of but I never have
gt; gt; gt; gt; all 150
gt; gt; gt; gt; items reporting event's. SO this program needs to be able to look at the new
gt; gt; gt; gt; data
gt; gt; gt; gt; determine the event name , find the cell on the actual spreadsheet with the
gt; gt; gt; gt; same
gt; gt; gt; gt; event name and then add the count in the column with the current date.
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; HELP!
gt; gt; gt; gt;