WallyBackman
New Member
- Joined
- Apr 8, 2007
- Messages
- 21
I have long enjoyed this great site and this is my first post.
How would I go about writing VBA to select the Primary Sort Column conditionally based on values outside of the data that is selected for sorting? Something like:
IF(AND(Z1>=AA1,Z1>=AB1)), Primary Sort Key = Col C,
Else IF(AND(AA1>=Z1,AA1>=AB1)), Primary Sort Key = Col F,
Else IF(AND(AB1>=Z1,AB1>=AA1)), Primary Sort Key = Col I
How would I go about writing VBA to select the Primary Sort Column conditionally based on values outside of the data that is selected for sorting? Something like:
IF(AND(Z1>=AA1,Z1>=AB1)), Primary Sort Key = Col C,
Else IF(AND(AA1>=Z1,AA1>=AB1)), Primary Sort Key = Col F,
Else IF(AND(AB1>=Z1,AB1>=AA1)), Primary Sort Key = Col I
