Where does the data reside? Is it possible to set up an ODBC
connection to the source of the data?
For example, you could think of setting up a very simple query in SQL
(you can write it in Microsoft Query, which returns the results
directly in Excel) to this end. Have you spoken to the IT department
of your organization?

Dave Peterson- Hide quoted text -

- Show quoted text -

Thank you for the response. *That is what I feared. *I am unable to
manipulate the layout of the table, as it is a canned report that is
spit out of an online system, and we would like our users to as little
manual manipulation as possible. *Do you know of any other formulas
that could help with this?- Hide quoted text -

- Show quoted text -