You can use the pivot table for doing what you want - you might just
need to add a column so you can identify "Ordered" by a unique
identifier - i.e. Date, or "Ordered" - YES or NO, etc. The nice thing
about pivot tables it takes NO extra work on your part once you have
the basic information. It is just a matter of using the columns you
alread have and then deciding how to place them in the PIVOT Table.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=501710