VBA Macro sorting

**sflemings** · 08-31-2009, 06:37 AM

Hi,

Here is my question.
I have information from column A to column F.

I have this macro to sort column A, with the selection expanded.

Please Login or Register  to view this content.

I now want to sort column B but I also want this to be dynamic, i.e. the total information in the worksheet may change. It's all filled in with formulas from another sheet.

Example
Col A Col B
AED KWD
BCD XCD
AED USD
EUR ZAR
AED EUR

So after sorting column A with the selection expanded I get this.

Col A Col B
AED KWD
AED USD
AED EUR
BCD XCD
EUR ZAR

Now I want to sort column B according to the items in column A like so

Col A Col B
AED EUR
AED KWD
AED USD
BCD XCD
EUR ZAR

Any idea if this is possible?

**JBeaucaire** · 08-31-2009, 06:50 AM

Hi sflemings. Be sure to read through the Forum Rules so you can use and follow them effectively. For instance, you'll need to edit that post above and put code tags around that code you used. (Like I did below...)

In Excel 2003 you can filter by up to three "Keys" all at once). Also, you do not have to "select" a range to do something to it.

Please Login or Register  to view this content.

**sflemings** · 08-31-2009, 07:39 AM

Perfect. Thanks for that.

**JBeaucaire** · 08-31-2009, 08:01 AM

Glad to help. (and thanks for updating post #1)

=====
If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)