Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Method problem in Excel VBA.... | Excel Worksheet Functions | |||
Question using the excel find method in vba? | Excel Programming | |||
Excel VBA .Find method - am I clueless? | Excel Programming | |||
.Find Method for Excel 2002 | Excel Programming | |||
Excel Find Method | Excel Programming |