G
Guest
I have a master account sheet that lists orders and their contents. 10 orders
of up to 10 items currently but it could expand. The items could or could not
be replicated in each order. The problem lies in that I need to list all
items ordered in a summation list and that I cannot use VB.
Quantities and values can be done with a vlookup function but I'm scratching
my head over how to get the original list.
The sheet has sections like the following
order A
Item 3
Item 5
Item 7
Item 8
Order B
Item 5
Item 3
Item 1
Order C
Item 6
Item 5
Etc.
and a summation section that lists all those listed above: (the problem child)
Summation:
Item 1
Item 3
Item 5
Item 6
Item 7
Item 8
Would a set of arrays work?
of up to 10 items currently but it could expand. The items could or could not
be replicated in each order. The problem lies in that I need to list all
items ordered in a summation list and that I cannot use VB.
Quantities and values can be done with a vlookup function but I'm scratching
my head over how to get the original list.
The sheet has sections like the following
order A
Item 3
Item 5
Item 7
Item 8
Order B
Item 5
Item 3
Item 1
Order C
Item 6
Item 5
Etc.
and a summation section that lists all those listed above: (the problem child)
Summation:
Item 1
Item 3
Item 5
Item 6
Item 7
Item 8
Would a set of arrays work?