I am sorry for a vague or rather a totally obscure title but I didnot know how best to explain what I needed.
I obtained sales information for our small gas station company from our database.
I have four basic columns. A date column, item number, item description and its sales for that particular day.
so it looks some like this,
The list is several entries for each day and I want to do analysis for say a month. So I have entries for each day and its corresponding number.
What I wanted was to have all these values added based on their item number. That is, probably a macro(?) which would peruse the item list and if it found a duplicate entry, it would add the total in sales column to its initial count and maybe paste it into a different sheet. I can completely do away with the dates column.
All I want is, for a particular period, how many of particular items I have sold.
Any ideas on how to go about this problem or if their is a similar macro anywhere online which I could use?
Thanks a lot for your consideration.
I obtained sales information for our small gas station company from our database.
I have four basic columns. A date column, item number, item description and its sales for that particular day.
so it looks some like this,
PHP:
date code description count
7/1/2008 101085 CAMEL TURKISK ROYA 2
7/1/2008 101090 CAMEL TURKISH GOLD 1
7/1/2008 101100 CAMEL KS. BX. F.F. 5
7/1/2008 101140 CAMEL KS. BX. LT. 14
7/1/2008 101141 CAMEL WIDE KS. BX. 1
7/1/2008 101142 CAMEL WIDE KS. BX. 1
7/1/2008 101148 CAMEL MTHL. KS. BX 1
7/2/2008 101090 CAMEL TURKISH GOLD 3
7/2/2008 101100 CAMEL KS. BX. F.F. 1
7/2/2008 101140 CAMEL KS. BX. LT. 11
7/2/2008 101141 CAMEL WIDE KS. BX. 2
7/2/2008 101148 CAMEL MTHL. KS. BX 1
7/2/2008 101149 CAMEL MTHL. KS. BX 2
7/2/2008 101480 KOOL MTHL. KS. BX. 4
7/2/2008 101540 KOOL MILD MTHL. KS 3
What I wanted was to have all these values added based on their item number. That is, probably a macro(?) which would peruse the item list and if it found a duplicate entry, it would add the total in sales column to its initial count and maybe paste it into a different sheet. I can completely do away with the dates column.
All I want is, for a particular period, how many of particular items I have sold.
Any ideas on how to go about this problem or if their is a similar macro anywhere online which I could use?
Thanks a lot for your consideration.