C
Cuyler
I'm using column 'A' for our parts list, with some 45
different parts in all, and 'Row 1' for the dates of the
month, 1-31 in most cases. I want to link the raw data of
parts sold, to a summary sheet to come up with a daily
count, by part, of individual parts sold.
For example:
Column A, lists, top to bottom, parts 1 thru 45
Row 1, column B, lists dates of the month 1-30(31)
So on the 5th, I might have sales of twelve Part #44 and
three of Part #22, and so on. The sales are entered as
they come in, but only in date order. The Part numbers
can be in any order.
What's the best way to come up with a summary like this?
different parts in all, and 'Row 1' for the dates of the
month, 1-31 in most cases. I want to link the raw data of
parts sold, to a summary sheet to come up with a daily
count, by part, of individual parts sold.
For example:
Column A, lists, top to bottom, parts 1 thru 45
Row 1, column B, lists dates of the month 1-30(31)
So on the 5th, I might have sales of twelve Part #44 and
three of Part #22, and so on. The sales are entered as
they come in, but only in date order. The Part numbers
can be in any order.
What's the best way to come up with a summary like this?