-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
sort key
-
P
Sort Dynamic Range - help please
I've looked everywhere and cannot work out the way to reference the sort key in my dynamic range. I believe it's relatively easy but my VBA still not up to it. I have a dynamic range that I want to sort using a column within the range. The range is A18:AR25, refers to...- prowebcommerce
- Thread
- Replies: 8
- Forum: Excel Questions
-
C
Excel VBA Sort Separate Groups of Columns with same Sort Key - Seeking Better Efficiency
Hello, I have a worksheet with data similar to the table below: <tbody> (Hidden) Sort Name Cost (Empty for Spacing) 1 1 AAA $20 2 2 BBB $18 1 3 CCC $25 2 4 DDD $15 </tbody> This group of 5 columns repeats up to 300 times across the worksheet. I currently have a macro that will...- cfrehner
- Thread
- Replies: 4
- Forum: Excel Questions
-
W
Conditional Primary Sort Key
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...- WallyBackman
- Thread
- Replies: 0
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Help with summation of different rows in 1 column
- Started by bassemjohn1
- Replies: 30
[B]Hello guys, [/B] I am new here and am in need of your help,I have a report that is really taking a huge time and all I need is a [B]way to sum... -
Excel VBA Code to Compare Rows in Two Different Sheets and Highlight Only the Cells that are different/unique
- Started by Walkerwood9
- Replies: 25
I have a workbook that has two sheets in it and I want to compare these sheets (Test1 and Test 2) and highlight only the individual cells that are... -
COUNTIFS function help please
- Started by andrewmurray86
- Replies: 25
Hi all, This is my first post here: I'm attempting to identify the smallest number within a column. I have a series of sheets with a column... -
Move row automatically to the bottom of the sheet when cell changes
- Started by CindyLou
- Replies: 23
I have a column of "Open" and "Closed" items. When the cell is changed to "Closed," I'm trying to get the whole row to go to the bottom of the... -
Change date format on import
- Started by namloop
- Replies: 37
Good morning I am importing some data and I am having two different issues in col. B. In rows 3 this data says Nov-9 (the 9th of November) when I... -
Problem with macro
- Started by Jeeremy7
- Replies: 20
Hello, I have a macro running but i think some informations are in double so the macro doesn't work.. If somoene could help it would be really...