James Edward Gray II <james / grayproductions.net> writes:

> Christian Neukirchen's short solution (not shown) does away with
> sub-header and subtotal lines.  That filter tacks on the Salesperson,
> Customer and SA Sort Code to each product entry.  This makes all the
> needed information available on every line.  This is a big win for
> using Excel's filters, making the report a lot easier to examine and
> change.
>
> When I did this project for work, I did the same thing.  However, I
> put the metadata at the back of the line and left in the sub-headers,
> subtotals and blanks.  I also added a column to identify each type of
> line: Header, total, data or blank.  This gave me all the same
> benefits as Christian's code has, while keeping the familiar format.
> I could filter down to the "data" lines to have nearly identical
> results.  This feature turned out to be a big hit, drastically
> increasing company productivity.

Now, that's a really nice idea...

-- 
Christian Neukirchen  <chneukirchen / gmail.com>  http://chneukirchen.org