-
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
-
loop through merged cells in a Column to get their addresses
- Replies: 46
I have one column. say column A, which has multiple merged cells of different ranges. for example first cell is merged from A2 to A15 whereas... -
Split a Column into 2, use a character limit that does not cut words in half.
- Replies: 31
Title says it all. I have huge columns of data that can only be 30 characters long. I want to use a formula to split the column into two. The... -
change colour of picture based on cell value
- Replies: 46
hello again guys I have found this video of Bills that explains how I could dynamically change the .width & .Height of a shape in excel, but I am... -
Preventing duplicates
- Replies: 24
Hi everyone, I am using a userform to add data to my worksheet, my userform uses a combobox to to show the list that exsists but also allows for... -
EXCEL SHEET auto enter Dates
- Replies: 23
Hi All , I am came to this forum after a long time , this is the great platform and with awesome people , where stranger of no where will help... -
Code giving run-time error when called, but not when placed on worksheet.
- Replies: 23
The code listed below runs on the worksheet, but gives a [B]Run-time error '424': Object required[/B] when called. I called the code, because when...