darke_fyre
New Member
- Joined
- Aug 12, 2013
- Messages
- 1
Hi everyone!
I've been trying to figure out how to autosort a file for work, but I can't quite figure it out...
Basically, what I have is a worksheet with 21 columns and 15,000 rows. The first column contains the product code and the third contains the product name - for this sorting, these are just static values that shouldn't affect the sorting at all. The second column is the important one (the B column) and should be the value that determines the sorting. So basically I need it to sort in Descending order. The 6th all the way through to 21st columns are the columns whose values i will actually be modifying - the B column contains a formula that depends on these columns. So what kind of code do I need to have in order to do this?
Thanks in advance for the help! I really appreciate this... I really can't get this to work!
If you need more clarification or something, just ask and I'll add more details as needed.
Kevin
I've been trying to figure out how to autosort a file for work, but I can't quite figure it out...
Basically, what I have is a worksheet with 21 columns and 15,000 rows. The first column contains the product code and the third contains the product name - for this sorting, these are just static values that shouldn't affect the sorting at all. The second column is the important one (the B column) and should be the value that determines the sorting. So basically I need it to sort in Descending order. The 6th all the way through to 21st columns are the columns whose values i will actually be modifying - the B column contains a formula that depends on these columns. So what kind of code do I need to have in order to do this?
Thanks in advance for the help! I really appreciate this... I really can't get this to work!
If you need more clarification or something, just ask and I'll add more details as needed.
Kevin
