vba macro to sort the column data by a word that starts with"Elect"

[mvneema]

Hi,

I have an input excel file that has data columns from A to I. In the attached sheet(Sheet3), The Column A is for Company, Column B is for Ticker, Column C is for Meeting ID, Column D is for Market Capital, Column E is for Proposal Number(Proposal#), Column F is for Proposal Text, Column G is for Votecast and Column H & I for Proposal Text and Votecast for the previous year. My Input file consist of all the data for each company i.e. each company has one more proposals. Majority of companies starts with the director-related proposal(i.e Column F values that starts with the "Elect xxx As Director" as 1,1.1,etc) but some companies do have those in Proposal number 3 or 5 just like the Company "Tyco International"in the input sheet(Sheet 3). My requirement is to sort those data with the word "Elect" and move that data to first set and rewrite their proposal number as 1.1,1.2,1.3, etc.and move the other proposal text(ColumnF) accordingly. I guess I have explained what it is i needed. I tried various ways of filter but it did not meet my need. I would like some help on this. I have attached the workbook with Sheet3 as Input and Sheet4 as the Desired Output.

Thanks,

[mvneema]

Can anyone help me with this as I am try it for few days.

[mvneema]

I tried with the custom sort and I get problem with tracking of range for each company. this is the following code

Please Login or Register  to view this content.

Can anyone please help with this???