I have an income statement [excel spreadsheet] run via our financial
reporting tool. Column A is hidden ; Column B contains line descriptions.
Columns D-F is for Consolidated Summary;
Columns OQ is for €œCompany A€� data, Columns SU is for €œCompany B€� data,
Columns WY is for €œCompany C€� data etc.

The report can be run for 1 company or all companies [ 20 in total].

My question is that I need to re -arrange the columns with company data as
per the above according to the company with the highest revenue. The revenue
total is on line 25.
The final spreadsheet should have the data for the company with the highest
revenue in cols OQ and the next highest in cols SU etc.

I would prefer the re-arranged columns to appear on the same sheet
["summary"] or if not then a new sheet [delete original "summary" sheet and
create new one].

Please let me know if you need more details.

How about copying all the data and transposing as you paste? Then you could
do a normal Excel row sort and transpose back again.

"manfareed" wrote:

I have an income statement [excel spreadsheet] run via our financial
reporting tool. Column A is hidden ; Column B contains line descriptions.
Columns D-F is for Consolidated Summary;
Columns OQ is for €œCompany A€� data, Columns SU is for €œCompany B€� data,
Columns WY is for €œCompany C€� data etc.

The report can be run for 1 company or all companies [ 20 in total].

My question is that I need to re -arrange the columns with company data as
per the above according to the company with the highest revenue. The revenue
total is on line 25.
The final spreadsheet should have the data for the company with the highest
revenue in cols OQ and the next highest in cols SU etc.

I would prefer the re-arranged columns to appear on the same sheet
["summary"] or if not then a new sheet [delete original "summary" sheet and
create new one].

Please let me know if you need more details.

I need an automatic routine ; so that third parties can run the reports

"Smallweed" wrote:

How about copying all the data and transposing as you paste? Then you could
do a normal Excel row sort and transpose back again.

"manfareed" wrote:

I have an income statement [excel spreadsheet] run via our financial
reporting tool. Column A is hidden ; Column B contains line descriptions.
Columns D-F is for Consolidated Summary;
Columns OQ is for €œCompany A€� data, Columns SU is for €œCompany B€� data,
Columns WY is for €œCompany C€� data etc.

The report can be run for 1 company or all companies [ 20 in total].

My question is that I need to re -arrange the columns with company data as
per the above according to the company with the highest revenue. The revenue
total is on line 25.
The final spreadsheet should have the data for the company with the highest
revenue in cols OQ and the next highest in cols SU etc.

I would prefer the re-arranged columns to appear on the same sheet
["summary"] or if not then a new sheet [delete original "summary" sheet and
create new one].

Please let me know if you need more details.