Excel VBA : Find Method
 

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.

Please let me know if you need more details.

Excel VBA : Find Method
 

I've replied to this in the Yahoo group you posted it to.
--
p45cal


"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.

Please let me know if you need more details.

Excel VBA : Find Method
 

Thanks ... I was desperate for a solution.



"p45cal" wrote:

I've replied to this in the Yahoo group you posted it to.
--
p45cal


"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.

Please let me know if you need more details.