Excel Formula Help

[shaikhstonevilla]

Hi,

Thank you for reading my thread.

I am newbie to excel and want to know formula/VBA code for following situation.

I have two columns in excel sheet. (Say Column A & Column B).

"Column A" Contains list of employees and "Column B" contains list of company.

I want to sort company (without filtering) and get list of its employees in different excel sheet.

Is there any formula or VBA Code ? It will help me a lot.

Thanks,
Sam.

 

[venkat1926]

I want to sort company (without filtering) and get list of its employees in different excel sheet.

do you mean to say you have data in diffenent sheets or in only one sheeet

suppose in one sheet the names are in column A and companies in col B. that means companies are repeaed in column B. each co;mjany may have more names.

just manually sort according to column B. no need formu;a or code.

copy original sheet somewhere safely

It woould be preferbale when you ask query you copy a small extgract of your data. it would be esier to suggest solutions.