Also, each day this data is updated to add or remove projects from each
Account. The accounts are listed in a workbook as shown in the example, but
each account is from a different site, perhaps 25 various accounts per sight.
What I would like to do, for example is sort all the jobs for all the
accounts located in Chicago, eliminating the need to scroll through data that
doesn't pertain to the accounts in Chicago. Does that clarify? Thanks!

"HKaplan" wrote:

To understand clearly, in the example data you provided, Row 1 is a
single merged "heading" cell spanning all the data columns. Row 2
contains the field headings, and the subsequent rows are the data?
And you have a line break before the next heading and data set? Or is
this an example of how you want the report to appear.

First thoughts are using a pivot table and custom sort.

Can you elaborate a little?