Grouping and Sorting Help!!!!

Hi guys. Please help me with the following:

I have 2 worksheets in the same workbook(see attached file). and i would like to do the following.

1. Sheet2: group columns "A" and "B" so when sorted they stay together.

2. Sort items in column "A" of sheet2 according to the column "A" of sheet1.

No changes are being made to sheet1. Only sheet2.

Thank you in advance for your help!!!!

Someone please help!!! BUMP...

What exactly do you need?

You need only to sort data present in sheet2 for column A and B together or you need also to groupo data of sheet1 in sheet2?

Another question: I can sort data of sheet2 very simple but I think is not simple to sort sheet2 according with sheet1?

Please tell me and I will help you.

Regards,
Antonio

Thank you Antonio. You helped me with first problem and your program worked great!

What I need now is this.

I have 2 worksheets. In Sheet2, I need to somehow group the data in columns A & B so when they are sorted they stay together.

Then I need to sort Sheet2 according to Column A of sheet1.

Column A of both sheets contain names of companies but they are in different orders. I need both sheets to have the same order.

Does that make sense? Thank you again Antonio

I did what you asked in the attached file.

I added a macro in Sheet1 that sort sheet1 and sheet2 so your data will appear in the same order.

Regards,
Antonio