Consider a Pivot Table. See
http://peltiertech.com/Excel/Pivots/pivotstart.htm
no i haven't considered a pivot table. the problem i have
is this is a report that i get daily and i have to sift
through a months worth of data to get my dollar figures.
can a pivot table be used in this case and work?
>-----Original Message-----
>Consider a Pivot Table. See
[quoted text clipped - 18 lines]
>> greatly appreciated.
>.
JE McGimpsey - 23 Jun 2004 00:43 GMT
> no i haven't considered a pivot table. the problem i have
> is this is a report that i get daily and i have to sift
> through a months worth of data to get my dollar figures.
> can a pivot table be used in this case and work?
Certainly - you can update your source daily and refresh the PT.